Using Slice Multiple Columns with one condition

AppSheet AppSheet Q&A
1

I want to create a slice which looks at multiple conditions across the row.

I have 30 columns of data, of which 18 columns with a condition of Red or Yellow or Green.

I want the slice to only show if any of the columns in show the text Red at least once.
So if column 5 in red and all other columns are Green this would show
if column 10 & 11 is showing red this would also show
but if all columns are green or Yellow this would not show.
I have been looking through the slice categories and not seeing any example of doing this slice.

Can someone help me with this?

Thanks

2

As the slice row filter:

ISNOTBLANK(
  LIST([column1], [column2], ..., [columnN])
  - {"Yellow", "Green"}
)
5 Likes
3

Steve,
So simple when you know
Thank you very much
Wonderful.

2 Likes