Formula to Flag Tasks that are on the Critical and / or Driving Path
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?
Best Answer
-
Thank you.
Answers
-
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
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
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…
- If a task is NOT on the Critical Path, does that mean by default that the task is Driving Path?
- 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.
-
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
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
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.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!