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 result must be one of the values from the ENUM options (ADDS_ONLY, READ_ONLY, UPDATES… etc), otherwise it won’t work.
will not result in one of the ENUMs, it will result in one of the row values from column Oversite.
i really don’t know why it doesn’t find column Evaluator, but i can say it won’t work for the purpose , because the result value must be one of the ENUMs and this will result in a Evaluator.
so… what you need to do is to try the idea from @11179 , supposing your table column Evaluator will contains the mail of people, and column Oversite which can be the access type like (Aministrator, User, Manager) or could be also a X, whatever…
the result being evaluated by the SWITCH is the resultant from the LOOKUP which will be “Oversite”.
that should definetly work.