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

[Nicolas_E-SILVA]

Hello everybody !

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

Thx !

[GreenFlux]

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]

Thank you so much ! I will try it.

[Nicolas_E-SILVA]

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.

[GreenFlux]

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

[Nicolas_E-SILVA]

@GreenFlux