If column [Status] = 'Approved' then [Run Date] must be >= today()
I cannot seem to get the syntax for this validation correct. Can anyone help out?
I understand the validation has to return true.
I think you should take a look at the validation functions for SharePoint. It's very similar to Excel.
A couple things to keep in mind:
So we'll need some sort of boolean statements returned... I'll assume your statement is to return
[Status] not equal to "Approved" Try something like the following:
if( [Status]="Approved", [Run Date]>=Today(), True )
Assuming that you are looking for list validation formula, the formula would look like below. Here is a support article from Microsoft on formulas