Formula that averages a column

Bridget Sloane
Bridget Sloane ✭✭✭
edited 12/09/19 in Formulas and Functions

HI Smartsheet community,

I need a formula that averages one column (# of jobs) if a checkbox is checked.  I think I need to use AVERAGEIF and ISBOOLEAN, but I can't get the syntax right.  Help!

-Bridget Sloane



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!