Hi!
Is it possible to use more than one Row filter condition?
I have a spreadsheet that I want to filter by two conditions to display the slice.
I have tried using an AND expression similar to this: AND({condition 1},{condition 2},{condition 3},…,{condition n})
My conditions are: [add to AppSheet]=‘yes’
ISBLANK([Last Contact Date])
I only bring certain rows into AppSheet and have been doing so using the [add to AppSheet]=‘yes’ slice option.
Now I want to create another slice based solely on those rows but add another condition.
If I can’t do this through Row filter condition, is there another way?
Thanks!
Hi did you try AND(ISBLANK([Last Contact Date]),[add to AppSheet]=“Yes”)
What formula did you try that didn’t work.
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |