League App ... entering scores (Admin rights)

[Jeff_Hager]

@Robert_Petitto I’m not sure if that method will word, but here is my reply from the other thread. I’d have to reverify, but I’ve had issues doing a lookup column into an array column on the related sheet. Admins need to be in rows in the admin sheet instead of columns.

Conditions for Edit and Delete

@kyleheney What I’m doing in my example is what you describe in your Edit2. Have an “admin” value in the sheet, create a multiple relation to an admins sheet that has the same “admins” value, then create a lookup that pulls all the admin emails. You have to make sure the admin records are in rows instead of columns. You would only have one email column in the admins sheet. In my screenshot, Email 1 is just a single email column of the row owner. Lkup-Admins is a lookup array of multiple val…