Help with IN() expression

Hi.

I am trying to compile a conditional expression for the system generated ‘Edit’ action. What I want to achieve is to allow all users to edit records where [Signature] is blank but if the user is an administrator they can edit records with a [Signature] value. The Administrator flag for each user is held in Employees Table.

What I have so far is
OR(
ISBLANK([Signature]),
AND(ISNOTBLANK([Signature]),
IN(“Yes”, Employees[Administrator])
))

Doesn’t seem to be working. I know I am missing something but not quite sure how to update expression accordingly.

Any help would be great, thank you.

0 34 1,261
34 REPLIES 34
Top Labels in this Space