How to add rows in Project Plan Sheet Summary Section without formulas?
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?
Answers
-
Are you able to provide screenshots for context?
-
Actual Start and Actual End are the new rows I added.
-
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)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!