How to populate % Complete from another Text/Number column that has a formula

David Pineda

Hi,

 

I'm trying to calculate and populate % Complete automatically using check boxes fields. For example I have 3 check boxes for 3 main activities per record. So I created I new field Count Check Text/Number field where I check if the first check box is checked the new count is 33%, if the second is checked with the first one the count will be 66% and if they are all checked the total will be 100%. And that all is working using nested IF statements. 

 

Now the quesition is how can I populate the % complete using tose values so the main % for each group  (Of all children records) of activities is updated correctly. I noticed when I copy the child % Count into the child % Complete, the main group % displayed an incorrect value.

 

I don't know if this is even possible.

 

Thanks,

David

J. Craig Williams

David,

 

First, if Project Settings are on, you can't put a formula in the % Complete column.

Al Project dependencies are locked from end-user formulas. 

 

 

However, you can calculate it yourself for display purposes.

See this thread for how the % Complete is calculated by Smartsheet:

 

https://community.smartsheet.com/discussion/percent-calculation

 

If the tasks have equal weight (regardless of duration or allocation) then your just looking at a sum of the complete ones / sum of the total ones

 

I hope that helps.

Craig