How can I hide different columns from the one sheet for different users?
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?
Answers
-
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
✅做我的帖子(s)帮助或回答你什么stion or solve your problem? Please support the Community bymarking 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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å ✭✭✭✭✭✭
Would they need to be able to edit the report too?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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å ✭✭✭✭✭✭
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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å ✭✭✭✭✭✭
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andre77 ✭✭
wow, thank You@Andrée Starå! now I can see it. through "Edit Row"...
-
Andrée Starå ✭✭✭✭✭✭
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!做我的帖子(s)帮助或回答你什么stion or solve your problem? Please support the Community bymarking 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andre77 ✭✭
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?