Referencing a detailed sheet from the master project sheet
New to SmartSheet, so I apologize if this is simple but I couldn't find the answer myself.
My organization uses a sheet to list all of our projects and under each project is the list of the activities. This is getting unwieldy. Is it possible to list all the projects on a master sheet and have the details on a separate, related sheet?
I am thinking that the detailed sheet could pass the needed information regarding progress to the master sheet and access to the detailed sheets could have different security.
Maybe there is a different way the office should be using sheets entirely.
Any insights or links to information would be greatly appreciated.
Answers
-
Hi @Liz O
If you're on a Business or Enterprise plan, what I would personally do in this instance is use a Report to gather multiple sheets in one place. There's a Sheet Link column that will make it easy to jump into the individual projects from that point.
You can filter a Report to only show specific rows from each project, for example a top, summary row (as long as there's consistent data across all of them).
Here's a free webinar on Reports that may be helpful: SmartStart: Reporting
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Absolutely, you can utilize master-detail setups in spreadsheets or explore project management tools like Asana or Trello for streamlined organization.
-
Hi @Liz O
I hope you're well and safe!
To add to Genevieve's excellent advice/answer.
- You could also break out the sheet into multiple reports—one per project.
Would that work/help?
I hope that helps!
Have a fantastic weekend & Happy Holidays!
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!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives