Calculate total % for Children rows where % Complete column is being populated by a formula
I have a Status Column and % Complete Column. I am using the following formula in the % Complete column to auto populate the % Complete.
=IF(Status@row = "Complete", "100%", IF(Status@row = "In Progress", "25%", IF(Status@row = "Not Started", "0%", IF(Status@row = "Out of Scope", "100%"))))
But when I try to calculate the total % complete for the children rows into the parent row I keep getting 0. I have tried several different paths and haven't found the solution.
If I remove the formula from the % Complete field and enter the percentage manually, I can then use this formula to calculate the overall % for the children rows.
But I want to auto populate the % Complete field based on the status that is selected.
Help Article Resources
Check out the Formula Handbook template!