AVG formula Divide If Zero Error

Options
whidbeycd
whidbeycd
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:

=AVG((Experience:Experience))

Tips on how to resolve the error? Thanks!

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @whidbeycd

    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:

    =VALUE(AVG(Experience:Experience))

  • whidbeycd
    Options

    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!