Forum Discussion

packercountryusa's avatar
packercountryusa
Copper Contributor
Mar 05, 2026
Solved

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's avatar
    Mar 09, 2026

    Could you please try this ..

    =IF(OR([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"), AND([Hours]>1,[Hours]<11), TRUE)