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.
Solved! Go to Solution.
Try putting your expression in Suggested values, not Valid If or Initial value.
Please post a screenshot of the error.
Ah, this is what confused me:
Suggested values isn’t involved at all.
You’re using UNIQUE() wrong.
See also:
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…
Try putting your expression in Suggested values, not Valid If or Initial value.
thanks
it works… sorry, i’ve written the formula in initial value instead of suggested…
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |