Don't show value previously selected in a form

[juanpa]

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?

[Steve · Accepted solution]

You’re on the right track.

Is the Name column of the Choices table of the same column type as the 1st Place and 2nd Place columns?

Please post a screenshot of the error message and the complete expression to which it refers.

[juanpa]

@Steve Base type of Column 1 was wrong (REF) I changed it and it works … Thanks!

[Steve]

Well done!

[Lynn]

Hi @juanpa , @Steve solved this for me.

Removing a selection from a dropdown list Questions

Hi I have been trying to do something similar and I can get First place with valid if Show Results[Horse_Rider] for SECOND place I have valid if SELECT(Show Results[Horse_Rider],[CLASS#]=[_THISROW].[CLASS#])-SELECT(Results[FIRST],[FIRST]=[_THISROW].[FIRST]) and this works. For THIRD place I want the list minus FIRST and SECOND I have tried variations of this but I am having trouble getting it to work SELECT(Show Results[Horse_Rider],[CLASS#]=[_THISROW].[CLASS#])-(SELECT(Results[FIRST],[…