AVG formula Divide If Zero Error

edited 09/01/22 in Formulas and Functions

New to formulas, attempting to find the average of survey results using the AVG function and the range for an entire column ("Experience") using the following:


Tips on how to resolve the error? Thanks!


  • Mike TV
    Mike TV ✭✭✭✭✭✭


    Maybe you have a cell (or all of them) that have a number in them but SmartSheet thinks it's text. Also, you don't need the double parenthesis around your formula range but it's not what's causing this problem. Try this:


  • whidbeycd

    Thanks! This still gave the same error but I think perhaps the issue was that the values were in a drop down - I just changed the Column Property to text and that fixed it

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!