Why is my percent complete not updating?

kibister

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?

SSFeatures

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.

Sarah Keortge

You will need to calculate the % for those summary rows using the CHILDREN function.

I suggest:

=IF(MIN(CHILDREN())=1,1,"")

kibister

But how when the parent task doesn't let you type anything in it because it says its being calculated by the children subtasks?