The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!

AVG formula Divide If Zero Error

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!

· Share on FacebookShare on Twitter

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭

    @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))

    · Share on FacebookShare on Twitter
  • whidbeycd
    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

    · Share on FacebookShare on Twitter

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!