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

expressions
(Desirée Alarie) #1

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!

#2

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

What formula did you try that didn’t work.