#DIVID BY ZERO

I have been using the following formulas to get averages, so far it has been working till now. I get #DIVID BY ZERO, where did I go wrong?


=AVG([Approval Metric]650:[Approval Metric]789)

=AVG([Response Metric]650:[Response Metric]789)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!