My settings below are denying Editors from deleting columns, but they are still able to delete rows. What do I need to do to prevent them from deleting entire rows?
Hi @gristexplorer, I think this may not be doing what you want. Instead of OWNER, try user.Access == OWNER and similarly for EDITOR. OWNER and EDITOR evaluate to just the text "owners" and "editors", regardless of the user. But user.Access will vary with the user, and evaluate to "owners" or "editors" or "viewers" depending on their overall access level.
The rules you show control what the user can do with data. Deleting columns is seen as a structural change. The fact that editors cannot do it may be due to a separate setting like this:
(see the
... delete ... columns part of that)