Column constraints using values from a different table

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.

1 Like