Valid if excluding [_THISROW]

[jonbowles84]

Hi Guys,

I have a "valid if"  formula for my column "Kit[Total Station]" that works, but I need it to not include this entry.

I.e. this formula doesn't allow any entry, as once one is chosen it exists in the Kit[Total Station] column.

I guess I need to change it to be some kind of count <1 type formula?

Any ideas?

SELECT(
    Equipment[Plant ID],AND(
        [Type] = "Total Station",
	NOT(IN([Plant ID], LIST(Kit[Total Station],Kit[Other]))
    )))

[TeeSee1 · Accepted solution]

Try entering it in the Suggested Values instead of valid-if

[jonbowles84]

Perfect, thanks @TeeSee1 !!

[Joseph_Seddik]

I don't quite understand what you are trying to achieve, but I noticed a possible error in your expression. 

LIST(Kit[Total Station],Kit[Other]) --> This is a list of two items,

hence it is very probable that your expression below doesn't have any effect in the SELECT statement; it is like it did not exist. 

NOT(IN([Plant ID], LIST(Kit[Total Station],Kit[Other]))

If you are trying to see if the item is in either list you should use:

IN([Plant ID], Kit[Total Station] + Kit[Other])

____________________

List Addition | AppSheet Help Center