ENUM with options whether another cell meets condition

[cr130]

Hello,

I am trying to figure out how to only show the list of valid ENUMS under "Variant Owned" column;

So if column, "Holo", "Reverse", "Normal", "1st Ed Holo Opt" and "1st Ed Opt" are "Yes" than it will show as an option under "Variant Owned". Can anyone assist on an expression for that? Would it go under Valid If  section? Thanks in advance!

[dbaum · Accepted solution]

Yes, create the Drop-down from Valid_If. You could use an expression along the lines of the following (untested) draft:

{IFS([Holo], "Holo), IFS([Reverse], "Reverse", ...} - LIST()

[cr130]

Hello! 

I may be doing something wrong, I am getting an error;

[cr130]

I got it, thank you!