Is it the Oversite column that has the access level? what could be the values for Oversite?

Hej, In your LOOKUP formula , you are returning the Employee Name, you need to return “Oversite” column. Under SWITCH, you have “”,“READ_ONLY”, this is useless, cause in the end there is a “READ_ONLY” if none of the values are choosen. Could you plea...

I think Steve’s idea is really good in case you wanna type the emails in the formula. If you wanna have a column that controls the access, and you do, better use SWITCH + LOOKUP. In the table where you type the formula for “Are updates allowed?”, the...

help.appsheet.com LOOKUP() Get column value from row in table or slice Try reading this topic see you can figure out, otherwise post again, i try helping you.

You better have a table only for the users first. In each row, you add the user email and create a column with a category for the user. Example: Administrator, User, Manager, something like this. Then you create the rules in the Data>Table view as if...