In order to make columns “user specific” in your Google Sheet, you will need to have a dedicated row for each user.
Probably the best way to do this is to just make it part of your User Profiles sheet.
So…
- Create a column in your User Profiles sheet to hold the input value, and a second column to hold the result (note: these columns should NOT be User Specific)
- When a user enters the input value, it will sync back to the Google Sheet
- You then have your formula in the Result column, and the result will sync back to Glide and become available for use.
Note that you will need to ensure that you either:
- a) Have Row Owners enabled, or
- b) Have a filter applied “where email is signed in user”
…otherwise you’ll have all users writing to the same row and clobbering each others data.