Formula to Flag Tasks that are on the Critical and / or Driving Path

Berto_DA

I'm aware how to highlight these in the Gantt, but if I wanted a checkbox to flag which tasks are on the CP and which ones are on the DP, anyone have an idea how to do that?

Berto_D

Thank you.

Mark.poole

@Berto_DA

In the check box column

=IF(Column@row = “DP”,1)

=IF(Colmn@row = “CP”, 1)

Replace with column your looking = what your looking for to flag the check box

Berto_DA

Mmmmmm…. so I need a column that has the text either "DP" or "CP"? And then another column that has the IF statement?

Since I posted, I came up with a solution that begs another from question from me. Here's the question…

1. If a task is NOT on the Critical Path, does that mean by default that the task is Driving Path?
2. Is it one or the other in all situations?

If yes, then I came up with the following…

— Use the ISCRITICAL function to ID a CP task. =IF(ISCRITICAL([Task Name]@row), 0, 1)

— If the value is "0," then that task is - be default - a Driving Path task.

Appreciate anyone's thoughts. Have a great weekend.

Mark.poole

@Berto_D

No necessarily about those columns. I was providing the formula’s as an example since I have no further context to the sheet your working with.

Basically the IF(ISCRITICAL(column@row),0,1). Either it’s critical or it’s not. I did not realize CP = critical path and DP= Driving Path

Mark.poole

When you enable task dependencies in your project timeline, Smartsheet offers you three ways to visually track key dependencies:

• Critical path shows you which tasks affect the project completion date
• Summary path shows you which subtasks affect the completion date of a particular summary (parent) row
• Driving path shows you which predecessor tasks affect the start date of a particular task

You can easily share each of your paths with colleagues and managers to keep them apprised of your project’s status.

https://help.smartsheet.com/learning-track/smartsheet-advanced/critical-summary-and-driving-paths#:~:text=Critical%20path%20shows%20you%20which,date%20of%20a%20particular%20task

Berto_D

Thank you.