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 |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |