Formula Query

Tim Möhle
edited 12/09/19 in Formulas and Functions

I'm at a loss for how to perform a desired calculation within a sheet.


I have a list of rows that are assigned to owners (contacts).  Each row has a % complete.  I want a formula that will tell me what a given contacts overall completion rate is.

* Look up name in Owner column

* Add up all percentages in the "% Complete" column of all lines with that person's name

* Average the % to get a total % complete figure

I've considered some combination of COUNTIF and AVG, but can't figure out the right syntax.  Please help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!