I have 5 Enum columns that have a valid if formula to show a specific list (same list for all columns) to select. I want the list of columns that are blank to not show the values that were already selected in the other columns.
I already test this:
SELECT(Choices[Name]) for 1st place column
SELECT(Choices[Name])-LIST([1st Place]) for 2nd place
SELECT(Choices[Name])-LIST([1st Place],[2nd Place]) for 3rd and so on.
But I get the following error: “LIST has elements of mismatched types”
Is there any formula to make this happen?