User Specific Columns on Existing Columns

[Krishna_modi]

When we link our google sheet to the Glide App the option for making already existing columns on the sheet to “user specific columns” is greyed out. Is there a way around to make those columns user specific instead of creating new columns on the glide app datasheet.

[Darren_Murphy]

In short, no.

Columns can only be made user specific at the time they are created.

[Krishna_modi]

Thanks for the previous guidance,
So is there some alternative where I can take user specific values send it back to the google sheet for calculations and retrieve the calculations back to display on the app.

Also in case there isn’t an alternative is it possible to integrate some custom solution with the help of Glide that can workout with a google sheet existing in such a format?

[Darren_Murphy]

@Krishna_modi

So is there some alternative where I can take user specific values send it back to the google sheet for calculations and retrieve the calculations back to display on the app.

There are workarounds, yes.
But I generally encourage looking for Glide computed column solutions when it comes to calculations, and there are lots of good reasons for this.

Can you describe the calculations that need to be done? Perhaps we can guide you towards a solution using Glide computed columns.

[Krishna_modi]

So, I am actually working for a company and they already have all their calculations set up on google sheets which are very complex and do not wish to repeat the process of explaining the logic and transferring it to glide all together. The reason they chose a no-code platform like glide is that they’d not have to recreate the tool for users due to its complexity. However, the major issue we are facing is that we want multiple users to be able to access the same calculation sheets without affecting the output of one and other. That is why we opted for user specific columns to take user inputs.
So, if there would be some way that we could pull out user specific values from glide and send it back to the google sheets for further calculations it would be a huge help.

Meanwhile, I will definitely look into the glide computed columns as you suggested.

[Darren_Murphy]

Okay, understood.

The only way this will really work is if you have a dedicated row for each user in your Google Sheet. The obvious place to put these would be in your User Profiles sheet.

A very similar question to this was asked just yesterday…

Data from a user-specific column into my google sheet?

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 r…

[Krishna_modi]

Thanks a lot for your guidance