Average doesn't give me expected result

Hi there,

when i do a =ROUND(AVG formular as shown below i expect to get "2" for the average of 1 and 3.

But it shows 3. Any idea how to fix this?

Thank you,

Manuel


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Because your formula that is outputting the numbers is outputting the 1 as a text value which is not recognized. The AVG function is picking up on only the 3 since it is the only numerical value. Try removing the quotes from around the "1" in the number output formula and see fi that fixes things for you.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!