Help needed - AVG(Collect).. - #divine by zero error

Hi,  This is Ryan and help needed.

I'd like to get an average value either project status with ''in progress'' or ''complete'' whichever data available but with below formula, it shows #divine by zero' error.   When I try use only 1 condition either "in progress'" or "complete'', then it returns value.     

=AVG(COLLECT({OSAT project-Dashboard for chart_Progress}, {OSAT project-Dashboard for chart_category}, ="PD", {OSAT project-Dashboard for chart_P.status}, ="in progress", {OSAT project-Dashboard for chart_P.status}, ="complete"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!