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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!