Simple ValidIF problem

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 Solved
0 2 67
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4
OR(
  NOT(IN("None", [_THIS])),
  ISBLANK([_THIS] - LIST("None"))
)

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4
OR(
  NOT(IN("None", [_THIS])),
  ISBLANK([_THIS] - LIST("None"))
)

THANK YOU SO MUCH!!! So simple and just getting the best of me. Thanks again!

Top Labels in this Space