Help with #Divide By Zero


How do I adjust the syntax in this formula to avoid the '#Divide By Zero' error? I would like it to return a black cell for the months where this no data yet. I've tried using IFERROR in a variety of ways but that's either not the right solution or I'm not applying it correctly.

=AVG(COLLECT({Order Submission Time}, {Received By Month}, AND(@cell <= DATE(2022, 3, 31), @cell >= DATE(2022, 3, 1)), {OM Orders Received}, "Angie Blue"))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!