AVGW Formula with Conditions


Smartsheet Community:

Does anyone know how I can get Average Weigh Only if Criteria is Met?

For Example I want the AVGW if The Status is Open or Potential.

Current Formula without Criteria:

=AVGW([Risk Score]:[Risk Score], [Schedule Impact]:[Schedule Impact])



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!