I have a SharePoint list with the fields listed in bold at the bottom.
I currently am using the below formula to validate that when options 1 and 3 are selected, I am requiring ticket number is not blank before the item can be added to the list.
=IF(OR([Task Type]="Option 1",[Task Type]="Option 3"),IF([Ticket Number]="",FALSE,TRUE),TRUE)
Id like to add to this validation, the ability to force the start dates to be today or in the future, not in the past.
How would I combine my validation formulas? I have successfully got the below formula to work on its own for the start date, but can't seem to merge the 2 formulas so both are used for validation.
=[Planned Task Start Date]>=TODAY()
Task Type (Radio button selection)
Ticket Number (Single line of text field)
Start Date (Date Field)
End Date (Date Field)