Forum Discussion
CSimms
Apr 05, 2022Copper Contributor
List validation formula for multiple conditions
Hello, I'm trying to figure out how can I write the formula if I have multiple status drop downs that need to have different columns. For instance: Status "Under Review" needs to display the fie...
zeusPH
Apr 05, 2022Copper Contributor
Better to set conditional formula for each field.
For example:
In column "Request Initiated Close Date" edit the conditional formula for this field only put
=IF([Status]=='Under Review','true','false')
Do this for each column based on the required values for Status field.
CSimms
Apr 05, 2022Copper Contributor
zeusPH,
I should have been more clear in my post. I'm doing it at the list validation settings because I need "Request Initiated Close Date", "Under Review Close Date", and "Case Opened Close Date" to be required fields when the user selects certain statuses. From my understanding the only way to do this is in the list validation settings.
I should have been more clear in my post. I'm doing it at the list validation settings because I need "Request Initiated Close Date", "Under Review Close Date", and "Case Opened Close Date" to be required fields when the user selects certain statuses. From my understanding the only way to do this is in the list validation settings.
- Josh-BI-UKAug 15, 2022Copper Contributor
CSimms and zeusPH has anyone figured out a solution to this use case? I'm interested in the same problem. I.e.
I want a validation rule to check that if [Report_A Submission Rule] = "Not applicable" then [Report_A Deadline Date] must have a date. This would apply to multiple columns. E.g below
- Column 1) [Report_A Deadline Date] is a DateTime field.
- Column 2) [Report_A Submission Rule] is a choice field.
- Column 3) [Report_B Deadline Date] is a DateTime field.
- Column 4) [Report_B Submission Rule] is a choice field
- Column 5) [Report_C Deadline Date] is a DateTime field.
- Column 6) [Report_C Submission Rule] is a choice field.
>>>Choice field dropdown: "Options - no deadline", "Set deadline", "TBC".
The error message to display would be: "Required milestone, please provide a date!".