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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!