1

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)
Option 1
Option 2
Option 3

Ticket Number (Single line of text field)

Start Date (Date Field)

End Date (Date Field)

Improve this question

1 Answer 1

Reset to default
0

Try using below formula for your requirements:

=And(IF(OR([Task Type]="Option 1",[Task Type]="Option 3"),IF([Ticket Number]="",FALSE,TRUE),TRUE), [Planned Task Start Date]>=TODAY())

Official Documentation:

  1. Examples of common formulas in lists.
Improve this answer
3
  • Dang you are a genius! One follow up question, how would the validation formula change if I added validation on the End Date field as well? So I would verify the Ticket Number for being blank for options 1 and 3, and I would verify that the Start and the End Date fields had the current date or future dates entered? Commented Jul 20, 2022 at 15:53
  • Try this: =And(IF(OR([Task Type]="Option 1",[Task Type]="Option 3"),IF([Ticket Number]="",FALSE,TRUE),TRUE), [Planned Task Start Date]>=TODAY(), [End Date]>=TODAY() Commented Jul 20, 2022 at 16:23
  • Please Upvote(^) as it helped you & it will help others with similar question in future to find the correct answer easily. Commented Jul 26, 2022 at 17:00

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.