Permissions to only view certain rows in a large task list
We have an extensive "Mastersheet" for each of our projects that contains a lot of information. We also have outside partners that we want to give permission to view only SOME of the rows in the Mastersheet. Is there a way to do this without creating a report? The report becomes confusing because it doesn't indent to show parent/child status.
Best Answer
-
I am pretty sure the only way to do that is with the Dynamic view add on.
Answers
-
I am pretty sure the only way to do that is with the Dynamic view add on.
-
Dynamic view is probably the best solution as mentioned above.
If you format your parent/child rows you can have a report that does show the relationship clearly.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Do you mean format the font and background color?
-
To add to Ross and Dan's excellent advice.
I agree that if you can use the Premium add-on, Dynamic View it would probably be the best solution.
Another method is to include the hierarchy in the rows to show together in a report or include the parent rows.
A workaround I developed recently for a client that Dynamic View wasn't an option for. Was to show the information needed in another sheet without them having access to anything else. With this method, we can keep the hierarchy if there is a pattern and if it's always the same. If it's not, it would need to be updated manually.
Make sense?
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes, I started out by creating links from the Mastersheet to a new sheet so that any changes to those lines would follow through. The only problem is that it's then up to me to remember that any additional lines in the Mastersheet would need to be added to the other sheet if they are to be shown.
-
I usually use VLOOKUP or a combination of INDEX/MATCH.
The later option it needs to be more secure.
Make sense?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Makes sense. Thank you
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I don't understand the references to Dynamic View in this post. How does Dynamic View handle hierarchy?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives