I have a simple VALIDIF issue that just getting the better of me. Your thoughts and suggestions would be much appreciated.
I have a column, ConditionsOrdered which is an EnumList type. The default value of this is "None". What I'm finding is that my users are being lazy and not unchecking "None" when a condition is infact ordered. I'd like to set up a ValidIF so that if the user selects any condition in the list other than "None" and fails to uncheck "None" that there is a "invalid entry" error.
Thanks in advance for all your help!
Solved! Go to Solution.
OR(
NOT(IN("None", [_THIS])),
ISBLANK([_THIS] - LIST("None"))
)
OR(
NOT(IN("None", [_THIS])),
ISBLANK([_THIS] - LIST("None"))
)
THANK YOU SO MUCH!!! So simple and just getting the best of me. Thanks again!
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |