How to create a slice based off of a cell text value

[Kat]

Hey Guys,

I’m new to AppSheet so this may be a stupid question but here goes.

I am using a google sheet to record information about classes I am teaching online and I am trying to break down my data into smaller parts I can analyze. I want to see specific information based on what day of the week they happened on. For example, I want to exclude any rows that do not have the text value “Thursday” in the day column. I’m using the Row filter option in Slices, but nothing I use causes the rows I don’t want to be excluded. What expression do I need to use so that I only see rows with the “Thursday” text value?

Thank you,

Kat

[Kat]

Never mind, I figured it out.

Thank you!

[Lynn]

Hi @Kat
Please post your solution. It may help others searching your thread for help.

[Kat · Accepted solution]

I used the following expression in the row filter condition:
CONTAINS([Column Title:], “Cell Text”)

That being said, the first time I did it it didn’t work. When I stepped away and came back to it I found the slice was doing what I wanted so I think it just needed a bit of time to refresh.

Thanks!