AVG(COUNTIF) question


I am not a programmer and am trying to build a dashboard, but I need to figure out how to do a an AVG calculation.

Can someone help me with the formula?

I need to calculate the Average % Complete grouped by primary Assignment.

For Instance:

=AVG(% Complete) where Primary Assignment = "Business"

=AVG(% Complete) Where Primary Assignment - "Technology"

Any assistance would be greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!