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
Bubba JonesAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Keyboard CowboyCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keyboard CowboyCommented:
An approach was given - need more information from the contributor to finalize a solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.