I have a list of 35 email addresses and roles that look like this:
Each role type (Chairman, Vice Chair, Clerk) needs to have edit access to a different table in my app (Bills, Committees, Calendar).
I need to reference this table of email addresses and roles in the “Are updates allowed” formula in the data table, like this:
[list of email addresses corresponding to the “Chairman” role], “UPDATES_ONLY”, “READ_ONLY”)
What is the exact expression I need to enter to grant all the people in the “Chairman” role edit access to this table?
Thank you very much,