Forum Discussion
packercountryusa
Mar 05, 2026Copper Contributor
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 Vacat...
virendrak
Mar 09, 2026Iron Contributor
Could you please try this ..
=IF(OR([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"), AND([Hours]>1,[Hours]<11), TRUE)