Repeating Group Cell "IS NOT IN" Option Set

I have a repeating group cell and an option set. I would like to trigger a condition when the text value is not in the option set. Seems easy… !

Screen Shot 2021-01-26 at 9.28.48 AM

My logic would be “If the cell isnt in the option set then…”
I cannot find “is in”, I can only find “is not in” as a condition. I may be able to get around it with some sort of negation, but it just seemed strange. Goal: If the cell text is in the option set then turn the text blue. I may play with contains… and that didn’t work…

Screen Shot 2021-01-26 at 9.33.01 AM

Any ideas? Thank you!!!

would “contains” work? I’ve not used option sets yet so unsure if it’s an option.

Hi Alan,
This is my first Option set fiddle, and I tried contains and it didn’t seem to work either, but perhaps I got that wrong. Just seems a little odd.

Screen Shot 2021-01-26 at 9.33.01 AM

are you not comparing 2 different things there? should it not be:

All premium space type’s space type contains current cell’s space type?

Solved. Should have been using then display type for comparison.

This topic was automatically closed after 70 days. New replies are no longer allowed.