ISCRITICAL is FALSE for a PARENT task with CHILD tasks that are on the critical path
I have a project plan where the child tasks are on the critical path with ISCRITICAL = TRUE, but for the parent task, ISCRITICAL = FALSE. Is this expected behavior?
Context: It's a waterfall project. Only the child tasks have predecessors and successors so that the dates and duration for the parent task adjust when the child tasks are updated.
I have created a workaround to identify the PARENT row as critical if any of its child tasks are critical. Is it is expected behavior for the PARENT row to evaluate ISCRITICAL without regard to its CHILD tasks? If this is expected behavior, how do I request that Smartsheet update the documentation for ISCRITICAL to reflect this behavior?
Formula used for ISCRITICAL (Y/N): =IFERROR(IF(ISCRITICAL([Task Name]@row), "Y", "N"), "?")
Thanks in advance for your help.
Best Answer
-
Hi @CyberLady
Yes, this is expected - you can see this if you turn on the critical path in Gantt view, and look at the tasks that turn red:
Since Parent rows are rollup summary rows, they are not considered as individual tasks in the Critical Path. Here's more information:
Cheers,
Genevieve
Answers
-
Hi @CyberLady
Yes, this is expected - you can see this if you turn on the critical path in Gantt view, and look at the tasks that turn red:
Since Parent rows are rollup summary rows, they are not considered as individual tasks in the Critical Path. Here's more information:
Cheers,
Genevieve -
Thank you. This is exactly the behavior I am seeing in the project plan template I inherited. I will adjust the formula in our template to meet our needs.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!