I want to mark a column non-editable based on a value from another table.
Namely, a ‘users’ table hold details of the user, the up to date monthly expenditure he makes ( importrange from another sheet, this runs fully in backend in gsheets) and the balance he has on hand. Now I want to mark the column editable / non-editable where the users enter their expense (this is on a different table) based on how much expendtiture he makes in a month. Once a user exceeds his set limit, he will not be able to enter any expenses further.
I know how to use editable_if constraints, what I don’t know is how to incorporate the data from another sheet, if there is a way at all.
Please help.
You will want to use a LOOKUP() function.
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |