Forum Discussion

packercountryusa's avatar
packercountryusa
Occasional Reader
Mar 05, 2026

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? 

 

No RepliesBe the first to reply