extract unique data from an enum list

[alhazen]

I’m using this formula in the suggested field to generate a unique list from the role column (enum list type). However, it’s still not completely unique, as it keeps suggesting duplicate values. is there something wrong with the formula I am using?

[Arni_Kli]

@alhazen , try

…( UNIQUE(…) - [_THIS] )…. \\Or list([_this])

may be it will right.

[Steve]

", " (comma-space) should be " , " (space-comma-space).

SELECT(team[role], TRUE) could be replaced with just team[role].

The use of SPLIT() seems to serve no purpose in your expression. You could just use UNIQUE(team[role]) as the entirety of the expression.

[jballester]

Auto-complete other values
auto-completes previously entered values to encourage consistency and minimize typos.

[jballester]

SORT(
SPLIT(
Select(team[role],ISNOTBLANK([role]))
,",")
)

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/ENUMLIST-with-quot-Auto-Complete-Other-Values-quot-set-listed-in/m-p/319435#M94527

[alhazen]

Hey, @Steve The result isn’t what I expected. it should be a unique and properly parsed dropdown list.

[alhazen]

Hey @jballester It works, thanks.