When using AVG formula, is there a way to have blank entries in the columns without getting a #divid

Rachel Cox
Rachel Cox ✭✭
in Formulas and Functions

When using AVG formula, is there a way to have blank entries in the columns without getting a #divideby error?

image.png


· Share on FacebookShare on Twitter

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    https://community.smartsheet.com/discussion/comment/321366#Comment_321366

    OK so in your situation, there are no populated values at all! Got it. In that case, you just want to add IFERROR to your formula, to specify a replacement value in case of an error:

    =IFERROR(AVG([02/15/22]@row, [02/28/22]@row), "")

    This says, if the formula results in an error, just leave the cell blank (that's the empty pair of quotes at the end.) You could also specify a value, another formula, or some other message (such as "Hey, help a poor formula out, would ya? Give me some values to average!")

    Here I added another formula as the IFERROR value:

    image.png

    Here I added a more meaningful error message:

    image.png


    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!