One of the sheets we created is for service tickets. We have been experiencing an issue with having the users add a close out resolution. We would like to add a validation that would make the free text field called “Close out/resolution” be not empty when the field named “status” which is a selection field is selected as either “Closed - Complete” or “Closed - Not Complete” See screen shot below.
We tried using the Regex Ai and none of the code it generates works. Even tried making the field “not empty” and making a validation that it ignores the “not empty” when the Status is listed as “Open” Ai did not generate any code that worked for this either.
We would appreciate any help with this issue.
Thank you in advance.