Can you exclude children in parent date rollup?

I have a summary task with say, 5 children. Dependencies are turned on so the start and end dates are rolled up from the children. I have check boxes for the child tasks that include children (or not) in the summary task. If a check box is unchecked, that child is excluded in that summary. Is there any way to exclude the child's start and end dates from being rolled up under the parent if the box is unchecked?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!