Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Hi! Is it possible to use more than one Row ...

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!

0 1 347
1 REPLY 1

Hi did you try AND(ISBLANK([Last Contact Date]),[add to AppSheet]=“Yes”)

What formula did you try that didn’t work.

Top Labels in this Space