Why is my percent complete not updating?
I have a project plan which pulls in data from a
other referenced sheet. We track our development in a tracker, and have a dashboard and reports that help us understand where we are with progress for development. The percent complete pulls in automatically from a reference sheet into SubTasks in the project plan. However, the parent task % complete is not updating. If all of the sub-tasks are at 100% so should the parent. We bought into Smartsheet because of its ability to pull in data from linked sheets so this not working has caused quite a bit of tension at my organization. Anyone have any suggestions?
Answers
-
Hi @kibister,
Yes we can definitely make this work in SmartSheet. Can you paste the current formula that you use in your column so that I can expand it to make it work.
We will probably need to expand your formula to use IF and CHILDREN to handle the parent rows.
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds more features into SmartSheet.
- Report PDF generator that supports grouped and summarized reports
- Automatic sorting, sorting with filters, saving sort settings
- Hiding and unhiding columns, and spell checking
-
You will need to calculate the % for those summary rows using the CHILDREN function.
I suggest:
=IF(MIN(CHILDREN())=1,1,"")
-
But how when the parent task doesn't let you type anything in it because it says its being calculated by the children subtasks?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
