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

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

Find more posts tagged with

IT & Operations

Comments

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