Critical Path on Dashboard
I am looking to add the critical path to my dashboard. I saw suggestions saying to publish the sheet and add it as a web widget. But, after publishing, the critical path is not highlighted in that view. Am I missing something?
Best Answer
-
No, the default view of a Published sheet will be the full sheet; you'll need to select the filter from the menu each time.
Please let our Product team know that being able to set a filter as a default view for a Published link would be useful for your processes by filling in this form, here!
Thanks,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
The way I would do this is to set up a Filter on the source sheet which filters rows by the Critical Path:
Then you can use this filter in your published Web Content Widget (make sure you checked the "Share Filter" checkbox) to only show rows on the Critical Path:
Will this work for you?
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Is there a way to save this format to show up on a dashboard? Whenever I refresh, it goes back to original view. I tried copying the link after selecting filter and it still shows without filter on the dashboard.
-
No, the default view of a Published sheet will be the full sheet; you'll need to select the filter from the menu each time.
Please let our Product team know that being able to set a filter as a default view for a Published link would be useful for your processes by filling in this form, here!
Thanks,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you Genevieve. I will fill that out.
-
Hello Genevieve
I can create the CPM filter on the porjct plan and view CPM. All good no Issue.
But I wish to create a report showing Critical Path so I can list those task on Critical Path in Dashboard. But I can not see how to use Critical Path filer for creating a report.
Anurag
-
Hi @Anuraag
In this instance you'll need to add a helper column to your source sheet(s) so that there's something on each row to indicate if the row is on the Critical Path or not. Then you can use this Column as the filter for your report.
For example, you could have a Checkbox column (hidden, if needed) with the following formula as a Column Formula:
=IF(ISCRITICAL([Task Name]@row),1,0)
See: https://help.smartsheet.com/function/iscritical
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.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!