Multiple conditional statements in list validation

Question

Hi,&nbsp;&nbsp;I am trying to create a list validation formula that passes validation when the following conditions are met:&nbsp;&nbsp;1) [Action] column length is less than 500 characters&nbsp;&nbsp;OR&nbsp;&nbsp;2) [Outcome] column is not blank when [Status] column does not equal “Complete”(i.e. I want to require an entry in [Outcome] if the [Status] equals @ “Complete”).&nbsp;I’ve been trying to get both conditions working on their own before attempting to combine.&nbsp;The first condition above I’ve solved with =LEN((Action)&lt;500).&nbsp;The second condition above I can’t get to work at all.&nbsp;&nbsp;Any help coming up with the formulas and combining would be greatly appreciated.&nbsp;&nbsp;&nbsp;&nbsp;

ganeshsanap · Accepted Answer

laser132217&nbsp;Try using this formula:&nbsp;&nbsp;=OR(LEN([Action])&lt;500, IF([Status]="Complete", IF(ISBLANK([Outcome]), FALSE, TRUE), TRUE))&nbsp;Please click Mark as Best Response &amp; Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Forum Discussion

Multiple conditional statements in list validation

Share

Resources