How to add rows in Project Plan Sheet Summary Section without formulas?

elanadicocco

I want to add two more rows within the summary section of our project plan sheet. When I add these rows and insert text into a cell, the row gets populated with "Not started" and assigned a health. The current rows in the summary section do not get autopopulated but have the same formulas attached to them. These new rows are being added as if they are a task, but not within the task section of the sheet. How do I prevent the new rows from being assigned a health like the current summary rows? Or how do I remove the formulas?

Paul Newcome

Are you able to provide screenshots for context?

elanadicocco

https://community.smartsheet.com/discussion/comment/377352#Comment_377352

Actual Start and Actual End are the new rows I added.

Paul Newcome

What is in the parent row of those two rows you are wanting to add? Basically you will need to adjust both your Health and Status columns to only run when the parent is not "whatever that is".

=IF(PARENT([Task Name]@row) <> "whatever that is", existing_health_formula)