Hide a column using an editable_if filter

Currently I have two table for a time off request form I'm making, one is "Form Responses" and the other is "Emails". In the emails table it contains a list of users with their emails and departments, and those users are able to edit the Status field for form responses that match their department.

What I'm trying to do is create an editable_if expression that will make it so users in the Emails table are not able to edit the status field of their own request. However it seems that whatever expression I use, they are always still able to edit them. 

This is the expression I'm using:

 

AND(
    IN(USEREMAIL(), Emails[Email]),
    ISNOTBLANK([Department]),
    [Department] = LOOKUP(USEREMAIL(), "Emails", "Email", "Department"),
    USEREMAIL() <> [Employee Email],
    NOT(
        AND(
            IN(USEREMAIL(), Emails[Email]),
            [Department] = LOOKUP(USEREMAIL(), "Emails", "Email", "Department"),
            USEREMAIL() = [Employee Email]
        )
    )
)

 

Any suggestions are appreciated, thanks!

0 1 45
1 REPLY 1

I even tried to fully simplify it by saying USEREMAIL()<>[Employee Email] and the field was still editable.

Top Labels in this Space