Validation Column Not Working

Question

I have a Validation Setting column which seems not to be working with the formula =RTW>=StartDate and I get error:

'Something went Wrong'

However it works if I have the formula =RTW=>Today() it does work, How can I get the validation be ColumA=>ColumnB?

Ganesh Sanap - MVP · Accepted Answer · 2021-04-09 09:08:53Z

0

You cannot add reference to other columns under Column Validation settings.

You have to add this formula under List Validation settings.

Follow below steps:

Updated from Comments:

Use below formula in list validation settings:

=AND([EndDate] >= [StartDate], [RTW] >= [StartDate])

answered Apr 7, 2021 at 5:19

42.8k21 gold badges30 silver badges58 bronze badges

I already have =[EndDate]>=[StartDate] in this validation, can I combine both? if so which formula is correct as always get confused with the IF/AND/OR logic. Also why would the validation within the column not work? what kind of validation can be used in the column?
– mtagliaferri
Apr 9, 2021 at 6:47
In Column validations, you cannot add reference to other columns. For updated formula, check my updated answer.
– Ganesh Sanap - MVP
Apr 9, 2021 at 9:06
Thanks for your help!
– mtagliaferri
Apr 13, 2021 at 17:09

Add a comment |

1 Answer 1