avg(Collect) not working

Robert S Fike

Can anyone see the flaw in my fomula.

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

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

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.

Genevieve P.

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!

Robert S Fike

Thank you