Active & Inactive Project Rows
Is there a way to make certain project rows active or inactive, so the date or % complete doesn't get calculated into the parent row? I've found a ways to use formulas to achieve this, but was curious if there's a more simple way to do this.
I realize you can just delete the row if it's no longer needed. However there might be tasks/milestones that are deemed out-of-scope, but we don't necessarily want to delete. Just check off as "inactive", so we have a record of it.
Right now, this is how I'm accomplishing this.
1) Create a "Count" column and add the formula below for each child row: =COUNTIF(Active@row, 1)
2) Add the following formula below for the parent rows: =SUM(CHILDREN())
3) Add the following formula to the parent rows for the % completed: =SUM(CHILDREN()) / Count@row
Answers
-
Unfortunately, if you have project settings turned on, which you likely do if you are automatically calculating percent complete then you cannot make adjustments to this calculation. You can do something similar to what you are doing now to calculate percent complete. The project settings percent complete is weighted based on task duration, so if you want to account for that you would need to incorporate the weighting.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives