Hide all rows with the "done" status from a specific email

[SanyaCLAUS]

I have an application that has an order status ("Not Done", "In Progress", "Done").

How can I hide all rows with the "done" status from a specific email?I did something similar through the security filter, but the problem is that others don't see what is hidden.

IF([Status]="Complete", 

USEREMAIL()="ShouldSeeEverything",    <!-- I need a list of emails here -->
USEREMAIL()="EverythingExceptCompleted" )

[Lynn]

Hi @SanyaCLAUS 

Maybe you could check out IFS() or SWITCH()

[Steve]

IN() - AppSheet Help