• Status: Solved
• Priority: Low
• Security: Public
• Views: 43

# Sharepoint Column validation

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 ?

Thanks
0
Bubba Jones
• 2
1 Solution

Commented:
The trick is to bring up excel - then write the formula you can using excel formulas.  You can quickly debug the formula and try various scenarios.
put in headers with the name of the columns on top row - then on the second row, put in your calculation
=if(a2>this, that, something else)...
get it right - then copy/paste into column validation - and replace cell references with [field names].
Be sure the formula evaluates to true when you want to allow the record to be saved.
Use  =AND( (a2 > this), (whatever < this), whatever else)
not if (this and that)..
I can write this equation but not right now - but this should help I hope.
0

Commented:
An approach was given - need more information from the contributor to finalize a solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.