Average % Complete If another Column is Checked

gwen.pino78261 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to get the % Complete for a project by averaging the Project Phases % Complete(which are parents to tasks).

  • =AVG([% Complete]:[Project Phase], 1) I used this formula to only calculate the values in the row that has been identified as a Project Phase with a check.
    • Answer is 8.39
  • =AVG(CHILDREN()) * 100 - These are the values that are calculated for the Project Phase
    • 63.33
    • 42
    • 5
    • 0
    • 0
  • Calculating by hand I get 110/5=22

Please explain how the formula is working (curious) and what is the correct formula to average my project phase %complete to get an estimation of project %complete. 




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!