Conditional Statements with Enum List Possible?

I have an enum list that presents as buttons.
Screenshot 2022-08-03 09.01.54.png
Is it possible to configure this in a way so that "No Follow Up" cannot be selected if any other value is selected? The others can be in multiples but no follow up's ability to be chosen depends on the condition of the others?

Solved Solved
1 7 1,068
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Valid If:

IF(
  IN("No Follow Up", [_THIS]),
  LIST("No Follow Up"),
  LIST(...)
)

Replace ... with the list of all valid values.

View solution in original post

7 REPLIES 7

Steve
Platinum 4
Platinum 4

Valid If:

IF(
  IN("No Follow Up", [_THIS]),
  LIST("No Follow Up"),
  LIST(...)
)

Replace ... with the list of all valid values.

I need a little more help with this. In my dev copy, i added the following:

IF(
In("No Follow Up",[_THIS]),
LIST("No Follow Up"),
LIST(Follow Up[Follow Up] - LIST("No Follow Up")))

to the Valid If section, and the expression appears to check out, however the UI now shows the Enum List that used to be buttons as an actual list ๐Ÿค”
What have i done wrong? 

Screenshot 2022-08-05 08.52.40.png

This:

LIST(Follow Up[Follow Up] - LIST("No Follow Up")))

Should be this:

(Follow Up[Follow Up] - LIST("No Follow Up"))

Hmmm.. That restores the button function, but i am still missing something. The value "No Follow Up" is not showing at all. I'd like all the options to be present, but No Follow Up not be able to be selected if other values are selected.

I realize at this point i can separate some things and have a Follow Up Y/N toggle, and the other values show in a separate column if Follow Up is Yes, but its become personal now and i want to learn something ๐Ÿ™‚

Whoops! Just remove - LIST("No Follow Up") from the expression.

This worked, thank you!

Just bumping this since it got buried over the weekend.
This is unfortunately not working as expected, as No Follow Up is not showing at all.

I may get this figured out this morning, but just wanted to keep the conversation active

Top Labels in this Space