Proportion of % Complete
Hi,
I have a question. Under the % complete, I completed 4 tasks under Parent Row Location, however on the row of Location, it still showed 0% complete. It seems it won't automatically adjust the level of % of completion. Do you know what's wrong with that? I did set the formula in the completion Progress column: =IF([% Complete]7 < 0.25, "Empty", IF([% Complete]7 < 0.5, "Quarter", IF([% Complete]7 < 0.75, "Half", IF([% Complete]7 < 1, "Three Quarter", IF([% Complete]7 = 1, "Full"))))). However, I don't know if it will affect the result on the % complete column. Please advise. Thanks!
Answers
-
Hi @AAL,
You can adjust the formula to do all rows quite easily:
=IF([% Complete]@row < 0.25, "Empty", IF([% Complete]@row < 0.5, "Quarter", IF([% Complete]@row < 0.75, "Half", IF([% Complete]@row < 1, "Three Quarter", IF([% Complete]@row = 1, "Full")))))
You can then use this as a column formula (right click on the cell to do this).
However, you'll still need the % Complete to be updated. For the tasks, this is presumably done manually, but for the parent rows you can do it with a formula - assuming the tasks are equal in terms of weighting. If so, then this formula should work:
=AVG(CHILDREN([% Complete]@row))
Using similar data to yours, this would give a result like this:
Hope this helps, but if there is anything else then just post! 😊
-
Thank You Nick for your prompt response.
-
I believe this was also already answered in another thread. You need to enter the End Dates since you are using dependencies.
https://community.smartsheet.com/discussion/comment/381469#Comment_381469
-
Thank you, Paul.
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