Enum data from other column error

[simone_checchin]

Hi to all,
I have this problem.
I’m trying to populate an Enum column with another column data and also allow other values but when i try to put the formula in the seggested values it shows me this message
“The expression is valid but its result type ‘List’ is not one of the expected types: Enum”
I’ve tryed this formula UNIQUE(table name[column name]).

Many thanks.

[Steve]

Please post a screenshot of the error.

[simone_checchin]

[Steve]

Ah, this is what confused me:

simone_checchin:

when i try to put the formula in the seggested values it shows me this message

Suggested values isn’t involved at all.

You’re using UNIQUE() wrong.

See also:

help.appsheet.com

ANY()

One arbitrary list item

help.appsheet.com

INDEX()

One specific list item

help.appsheet.com

UNIQUE()

Unique items in list

[simone_checchin]

If i write the formula in the “Valid if” it works, an I see al values in the dropdown menu, but I can’t enter new value…

[Steve · Accepted solution]

Try putting your expression in Suggested values, not Valid If or Initial value.

[Maharlikans]

thanks

[simone_checchin]

it works… sorry, i’ve written the formula in initial value instead of suggested…

[Steve]