Exclude items from a valid if statment

[Mark_Taylor]

I have a valid if statement that returns a list of potential values that are associated with a previous column

SELECT( Objectives[Objective] ,
[Goal] = lookup(
[_THISROW].[Goal],
“Goal Assignments”,
“Goal Assignment ID”,
“Goal”
) )

This works to get me a subset of possible selections. (Run, Swim, Bicycle)

I would like to modify this valid if statement so that if I already created an entry for one of the options
Like “Run” then the only options display are the ones I have not select yet (Swim, Bicycle)

At present the app allows me to select “Run” but generates an error because there is already an entry, but I would to just not present the option at all if it has already been entered.

[Lynn · Accepted solution]

Hi @Mark_Taylor
You can subtract a LIST from another LIST

help.appsheet.com

List Expressions and Aggregates

List expressions use and/or produce lists of values.

SELECT(…)- LIST([…])

[Mark_Taylor]

Thanks I will give it a shot

[Mark_Taylor]

That did the Trick,

Basically did a

Select(All the Options I want) - Select(Any options I already selected)

Thanks