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

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 ?

Bubba Jones
Bubba Jones
  • 2
1 Solution
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.
Keyboard CowboyCommented:
An approach was given - need more information from the contributor to finalize a solution.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now