Critical Path Flag

Sebastian Mc

Is there any way to assign a flag (number 1 in a column) to those line items that are in the critical path?

Is expected that if the critical path changes, this flags change as well automatically.

Thanks for the help

Stefan

Hi @Sebastian Molina,

not as far as I know. But you can create a filter to show only items/rows on the critical path:

https://help.smartsheet.com/articles/504659-using-filters-to-show-or-hide-sheet-data

Is that an alternative option for you?

Hope this helps

Stefan

Sebastian Mc

@Stefan, Thanks for the answer!

Unfortunately, It does not solve my problem. I can certainly filter the items in the critical path... but those change... and I need to create a report with critical path from different sheets. Is there any way to make that work?

Thanks

Stefan

@Sebastian Mc ,

there is currently no good solution for what you want and I strongly recommend to

 Submit Product Enhancement Request Let us know how we can make Smartsheet better. 

Just to not mention these options:

You could use the web content widget to embed a Gantt view of the whole sheet in a dashboard. But whenever you open the dashboard you would need to set the filter critical path again and the widget shows all the UI elements of a sheet too. Not pretty.

You could also export the "critical path filtered" sheet as picture and embed that in a dashboard widget, but this time the title of the project will not be visible... Not so good too.

Hope this helps

Stefan

Sebastian Mc

@Stefan Thanks for the follow up.

I already did exactly what you suggested in the previous message. It's not ideal and especially and hard to maintain.

Lets see if the ticket that I will submit gets any traction

Thanks

Sebastian Mc

@Stefan

Is there any way to create a formula that you say:

"If <row x> is in the critical path, then checkbox=TRUE"?

Thanks

Kara Lumley

@Sebastian Mc Thank you for the submission! Right now, we do not have a formula for this - but we are looking into it.

Best,

Kara

Stefan

@Kara Lumley

+1 for that feature

greetings

stefan

Stefan

Hi @Sebastian Mc ,

did you see the announcement of the Baseline feature at Engage?

Scheduled for January and eventually usable for your use case.

greetings

stefan

Sebastian Mc

@Stefan

I haven't seen it, do you have a link where I can check that out?

Thanks!

Andrée Starå

Hi @Sebastian Mc

Here you go.

https://youtu.be/GPnhyj1ehwA?t=1116

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!