Filter Query

[Saleh]

I have a table called DB and with a column called Status.

The status values are typically:
‘In progress’,
‘Hide-not required’,
‘hide - completed’

I want to display all the rows where the Status column does not contain the word ‘hide’.

What code do I write in the 'Row filter condition;?

Many thanks

[LeventK · Accepted solution]

@Saleh
I believe you are trying to create a slice. You can use below expression for that purpose:

NOT(CONTAINS([Status],"Hide"))

[Saleh]

LeventK:

NOT(CONTAINS([Status],“Hide”))

Yes perfect. Thanks

[LeventK]

You’re welcome. @Saleh can you also mark my reply as the solution pls? Thnx.

[Saleh]

Sorry, can I just ask,
Can I also add another statement to that so it that it should filter the rows further s that it only shows rows where the column [Priority] has the letter “U”.

Thanks

[LeventK]

@Saleh
You can construct an AND expression:

AND(NOT(CONTAINS([Status],“Hide”)), CONTAINS([Priority],"U"))

OR

AND(NOT(CONTAINS([Status],“Hide”)), FIND("U",[Priority]) > 0)

help.appsheet.com

FIND()

Position of fragment in text