avg(Collect) not working

Robert S Fike
Robert S Fike ✭✭✭✭
edited 03/15/24 in Formulas and Functions

Can anyone see the flaw in my fomula.

image.png
image.png

I get divide by zero. Not sure why it is not seeing Job # 9234G

· Share on FacebookShare on Twitter

Answers

  • Scott Orsey
    Scott Orsey ✭✭✭✭✭

    Is the Lot Size a number? Why is the "50" in quotes? Could be a problem comparing a number to text.

    Hope this helps

    Be well

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

    · Share on FacebookShare on Twitter
  • Nick055
    Nick055 ✭✭

    Hi Robert,

    I've been playing around with this & I suspect the Job # Lot Size's are using a different character than ' which is causing it to not be considered equal. I've encountered something like this before when copying from an excel sheet / outside source.

    Let me know if this helps.

    image.png
    image.png


    · Share on FacebookShare on Twitter
  • Genevieve P.
    Genevieve P. Employee

    Hi @Nick055

    The two different ' marks will be read differently in Smartsheet, you're correct. This would prevent a match, as they'll be seen as different strings.

    You could use find-and-replace to find all curved marks with the straight ones, if that helps!

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

    · Share on FacebookShare on Twitter
  • Robert S Fike
    Robert S Fike ✭✭✭✭

    Thank you

    · 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!