I'm using a security filter so these records ...

[ktv]

I’m using a security filter so these records are only shown to the staff member who submitted the record - OR(IN(USEREMAIL(), Managers[Email]), USEREMAIL() = [User Email])

I’d also like to hide from this view all records with a Status of “CLOSED”.

Do I need to use the security filter for this, too, or is it done somewhere else?

[Sdfaheemuddin]

Use slices

https://help.appsheet.com/data/slices/slices-the-essentials Slices: The Essentials help.appsheet.com

[ktv]

Thanks @Sdfaheemuddin. Could you help me with the row condition field? The Status column has 4 options - STARTED, RECEIVED, CLOSED, and FOLLOW UP. I only want to hide columns marked as CLOSED.

[ktv]

Thanks again! (fyi your comment was flagged as spam for some reason)

[Sdfaheemuddin]

It’s weird

[Aleksi_Alkio]

If you already using security filter, you could do this extra filtering as well and no slice is needed. AND(OR(IN(USEREMAIL(), Managers[Email]), USEREMAIL() = [User Email]),NOT([STATUS]=“Closed”))

[ktv]

Thanks @Aleksi_Alkio. I thought something like this might be possible but since I already used the slice and it’s working I’m going to leave it as is. I’ll keep this in mind for future projects though!