Hi all, I have two sheets that I am trying to get to reference one another. One sheet is “Users” and the other is “Businesses”. In my app, a user signs up to claim their business and enters a set of information. I would like to have a boolean checkbox that says “Owner” (in the User sheet) as a way for me to give the owner permission to access their business account.
Ideally, I’d like this checkbox to result in the User’s email being entered in the “Row Owner” box for that corresponding business (in the business sheet). That way, I don’t need to go searching for the business or copy/paste with multiple steps.
Has anybody ran into this problem/found a work-around? Any response is appreciated Thanks!