And Expression for row filter condition

AppSheet AppSheet Q&A
1

I just need help with a slice row filter condtion.
Currently showing all that are not blank
not(isblank([Temp Loc]))
but need to also not show ones where [Temp Loc]=“Gone for Summer”
I keep getting errors with And expressions I try.
Please help.

2

Rallee_Chupich:

not(isblank([Temp Loc]))> but need to also not show ones where [Temp Loc]=“Gone for Summer”

So… does this work?

AND(
ISNOTBLANK([Temp Loc]),
[Temp Loc]<>“Gone for Summer”
)

Also helps if you provide some of the errors you are seeing so responses can be more accurate…

1 Like