How can I hide different columns from the one sheet for different users?

Andre77

Hi there!

I have a trouble. I'm sharing a main sheet to a few users and I would like to show them different columns from this main sheet. How can I do it? What will be better?

Christian Graf

Hello @Andre77

I would recommend making several reports of the main sheet, and only including the columns you want the certain people to see in those specific reports.

You can then share each report with the person.

Hope that helps,

Christian

Andrée Starå

Hi @Andre77

I hope you're well and safe!

Is the data sensitive, or is it ok for them to be able to see everything?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andre77

Thank You @Christian Graf ! I'll play with it)

Andre77

@Andrée Starå they can see only the columns I allowed.

Andrée Starå

@Andre77

Would they need to be able to edit the report too?

Andre77

@Andrée Starå if possible, I would like to allow them to edit a couple of columns.

Andre77

@Andrée Starå I created the reports for the each user and shared to them. now they can see and edit only allowed columns.

maybe you can suggest me an easier way 😀

Andrée Starå

@Andre77

Yes, but they can still view everything and also access the sheet.

If it's important that they shouldn't be able, too, it won't work with Reports that way.

Make sense?

Andre77

@Andrée Starå I have locked important columns and hide not allowed columns. now users can see and change only allowed its.

Andrée Starå

@Andre77

No, unfortunately, they can still open Edit Row or the sheet and see everything, but depending on the permissions, they won't be able to edit the columns.

Make sense?

Andre77

wow, thank You @Andrée Starå! now I can see it. through "Edit Row"...

Andrée Starå

@Andre77

You're more than welcome!

There are a couple of options to make it work.

• Premium App, Dynamic View
• Premium App, WorkApps
• Automated Update Requests
• I recently developed a (what I call), Dynamic View Light. It's pretty advanced, but in short, it uses cross-sheet formulas and INDEX/MATCH and a specific structure and method, so it's only possible to show data that should be available.

Would any of those options work/help

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andre77

@Andrée Starå

I read about Dynamic View, I think this is a better way but now we're using Pro Plane and don't have access to it.

Second question) How can I use "Search..." in the Report or it's possible only in the Sheets?

Li_Connell

dynamic view will work, but its not ideal for what you are wanting to do. it doesnt allow for editing straight in the row. it does a pop up to fill in the allowed fields. which is a pain if you are trying to fill in data quickly.