Converting AverageA from Excel to Avg in SmartSheet

I'm having a bit of an issue. I formula in excel that works great. However, when I pulled the project into SmartSheet, I lost all of my formulas. Most I have been able to work around and fix to accommodate SS, but I can't seem to get the one for AverageA to convert.

Original Formula from Excel:


When I try the same formula with AVG in SmartSheet, I receive the #Divide by Zero error.

Any assistance would be appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!