Multiple views of same project data with summary bars
I have inherited a GANNT smartsheet with activities structured by vendor, so each vendor has activities for every project phase. I now want to use the same data to present an overall project view summarised by project phase, with the vendor bars below. The summary bar would be duration for the project phase, rolling up dates from the vendor activities below. I can't quite see how to do this using reports or copied rows. I can add a 'Phase' column, and then report by phase - but not get a rolled up duration, or a report containing all project phases
Answers
-
Can I somehow link row data into a second smartsheet, then summarise differently?
-
Hi Colin,
Yes, you can!
You'd use a VLOOKUP or a combination of a INDEX/MATCH formula or even cell-linking.
What would work best depends on your specific structure and use-case.
Would that work?
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it 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.
-
More info:
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
- 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