is it possible to include a critical path in the report ?
is it possible to include a critical path in the report or in dashboard ? Unless there's some other way to get it out of the sheet into another sheet ?
Answers
-
Hi @Jacek Filip
The critical path is specific to each individual sheet or project, so it's not visible in a Report (although you are able to make Reports show Gantt view).
You could display one sheet's critical path by embedding a Published View of the sheet into a Dashboard with the Web Content Widget (see here), but again, this would only be for one specific sheet.
If you're looking to have some key data across many sheets in one overview sheet, you could copy/paste the key rows into a summary Sheet by using Paste Special and Cell-Linking in the data so that it stays live and updates when the source sheet updates. (See here for more information on cell-linking.) Keep in mind though that if you copy over certain rows and then create new dependencies, it could update the dates in the sheet which would erase the cell-linking to the original project, since the original project/source sheet has different dependencies than this sheet.
I hope this helps!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!