Hello everybody ! is it possible to have dif...

(Nicolas E-SILVA-PINHO) #1

Hello everybody !

is it possible to have different choices with respect to different conditions in a same enum column ?

Thx !

(GreenFluxLLC) #2

In Enum column settings, check Allow other values, then use a formula in SuggestedValues to generate you dynamic lists.

Try an IFS() or SWITCH() function, with nested SELECT() or FILTER() functions for each list. So you test for a condition, then provide the suggested Enum values (using formula that returns a list) if that condition is true.

IFS(is-this-true?, SELECT(), is-that-true?, FILTER())

(Nicolas E-SILVA-PINHO) #3

Thank you so much ! I will try it.

(Nicolas E-SILVA-PINHO) #4

It worked ! But I used LIST instead of SELECT and it was on the formula area “Valid if”.

Thank you for your help !

Best regards.

(GreenFluxLLC) #5

Awesome! Glad I could help. SELECT would work too if you select the keys of the reference table.

(Nicolas E-SILVA-PINHO) #6

@GreenFlux :smiley: