I have a worksheet that has alot of lists on them. How do I (if I can), use the ref feature for an enum list and point it to a column that let’s say is in the middle of this sheet (column L)? Or do I have to have each list I want to ref for enum lists on its own tab/worksheet for lookup purposes for the user in a dropdown or button form factor? Thank you.
So I figured out a couple of ways to do it. The one that isn’t producing the dreaded yellow triangle is the type as Enum, base type as Text and the suggested value referencing the sheet and column header. But I have a rogue selection button with no text at the bottom of the list. Maybe this is because there are empty cells below. In any case, how would I get rid of this?
Hi @ten4info
your column should be of type EnumList, base type Ref, source table: the one you need.
Then, in the Valid_If section (not Suggested_values), you must set this expression:
yourSourceTable[keyColumn]
2 Likes
@Aurelien unfortunately that doesn’t work.
Can you show us the error message ? This is the most interesting part 
1 Like
@Aurelien The question is if I can have a sheet that is dedicated to 20 or 30 lists in column format with a header, that a field in a table is referencing for an enum dropdown. I added a unique ID column to the reference lists sheet to try that as that table keeps deferring the key to the row number. And it appears that the table I am working with to deploy this process is giving me the error that I need a more stable key.
That makes sense with the error message. You may need to read this documentation about key-columns:
What is a key? - AppSheet Help
If you have a enum column, base type Ref ==> I suggest you replace it with type Ref, very simply.
If you don’t have a table with all the “Deal list”, then you might prefer using a column with type Enum, and Suggested value/valid_if: the one you already have.
1 Like