Need some Sharepoint Help. Working on a new Office 365 Site, new to Sharepoint.
On Thursdays every week, field workers put in for the time off they need the following week.
-If a teammate requests time off, and the reason is VACATION, AND they request more than 1 day off, and StartDateRequested >Today+10, save the record. (we request 10 days notice for big interruptions in the schedule)
-If a teammate requests time off, and the reason is vacation, AND they request only one day, and StartDateRequested>Today+2 (sometimes crews work Saturdays), save the record
-If a teammate requests time off, and [TimeOffReason] is anything but VACATION, ignore all else, save the record.
I am trying to do a column validation, but very lost in the sharepoint method, but stuck need a sharepoint guru
I quickly got over my head as I drafted the logic.
If [TimeOffReason] = Vacation, and [DaysRequested] >1 and [StartDateRequested] >Today+10, save the record, else pop the warning
The above are the actual field names
Is this even possible ?