List of values from a row

[mariomueller]

Hi,
I habe in a table for example 3 columns.

Mother	Father	PrimaryContact
Susi	Strolchi

I need to build a list for the column "PrimaryContact", where the values are "Mother" and "Father.
I have tried this with enum, but in the values I can't use the [Mother] Value.

I have tried to leave the values blank and use the LIST() command, but this does not work:
LIST([Mother], [Father])
The expression is valid but its result type 'List' is not one of the expected types: Enum

I have no idea what can I do to get the booth values Mother and Father into a enum column type.
Thx for your help.

[AleksiAlkio]

Try to use LIST([Mother],[Father]) with the Suggested values.

[mariomueller]

sorry, my fault with copy and paste...
I have tried LIST([Mother],[Father]) but I get the error message: The expression is valid but its result type 'List' is not one of the expected types: Enum

The column is from type enum and no matter what I take for base type like list, text... nothing works.
I use the LIST() command in the auto compute app formula.

[AleksiAlkio · Accepted solution]

You have it in a wrong place. Move it from app formula field to Suggested values field.