Does task info about being on critical path exist?

Hans Pfisterer

I would like to use something like =IS-ON-CRITICAL-PATH in a formula for the health indicator of a task. Does that function exist? I know Smartsheet can show the CP, but can a task identify itself for being on the CP or not?

Genevieve P.

Hi @Hans Pfisterer

There currently isn't a formula Function in Smartsheet that can immediately identify if a certain row/task is part of the critical path or not. Pease let our Product Team know that this is a Function you'd find useful by filling in this form, here!

Are all of your rows with data in the Predecessor column a part of your critical path? If so, you could use this as the validation for your formula... for example, IF the Predecessor column is <> "" (not blank). Would this work for you?

Cheers,

Genevieve

Genevieve P.

Hi @Hans Pfisterer

There currently isn't a formula Function in Smartsheet that can immediately identify if a certain row/task is part of the critical path or not. Pease let our Product Team know that this is a Function you'd find useful by filling in this form, here!

Are all of your rows with data in the Predecessor column a part of your critical path? If so, you could use this as the validation for your formula... for example, IF the Predecessor column is <> "" (not blank). Would this work for you?

Cheers,

Genevieve

Hans Pfisterer

Hello and thank you! I did let the product team know that this would be a useful function.

Your suggested workaround would not work, since all our lines - also the ones not on CP - do have predecessors.

James Keuning

So, my brain is pretty tired right now, and when I encountered this question a few days ago I decided to watch it for an answer. I understand that the answer is that Smartsheet can't do this.

But if I remember from my PMP days, we can identify critical path with a calculator, so it seems like we could make Smartsheet do it too. The Predecessor field can be parsed, so it seems like all the numbers are there.

Anyway, I am going to work on this when I am a little fresher.