Forum Discussion
SharePoint List (Not Column) Validation Settings
I have an creating a list that keeps of the amount of hours taken by an employee. I have two columns in this list - Reason & Hours
If the Reason column value is 'Paid - Vacation' or 'Unpaid Vacation', then the value of Hours must be greater than 1 and less than 11.
I have gone to the List > Settings > Validation settings and tried a few different formulas:
=IF(AND([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"),IF([Hours]>0,IF([Hours]<11,TRUE,FALSE),FALSE),TRUE)
=IF(AND([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"),IF([Hours]>0,IF([Hours]<11,TRUE)),TRUE)
I don't get any errors when saving either formula. When I enter another record manually or using the form, the record is entered, but no validation is being made when the [Reason] = "Paid - Vacation" and [Hours] = 45
Can anyone assist with this?