Critical Path on Dashboard

Kim Goldsmith

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?

Genevieve P.

Hi @Kim Goldsmith

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

Genevieve P.

Hi @Kim Goldsmith

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

Kim Goldsmith

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.

Genevieve P.

Hi @Kim Goldsmith

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

Kim Goldsmith

Thank you Genevieve. I will fill that out.

Anuraag

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

Genevieve P.

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