Moved a column & now have an error #Divid by Zero. How do I fix it?

Scott Powlus

I have some formulas that were effected by moving a column & condensing a column from 4 to 1 by using drop down menus. How can I fix these?

Mike Wilday

Can you provide some screenshots, examples, and the formula that you are using? That will help us out.

Scott Powlus

Here is the formula,

"HL" is one of the drop down tags that I would like to separate as a total.

=AVG(COLLECT([% Diff]:[% Diff], Type:Type, ="HL", [Open Date]:[Open Date], >=DATE(2020, 7, 1), [Open Date]:[Open Date], <=DATE(2021, 6, 30)))

Scott Powlus

Here is a shot of the sheet

Scott Powlus

The formula is housed in the Sheet Summary area on the right side of the page,

Mike Wilday

Are you getting any specific error?

The one thing I see that could be troublesome in the formula is that you may want to remove the =sign before HL.

Scott Powlus

Mike,

Thank you, but that didn't do it.

Mike Wilday

For more insight on the Divide by Zero error see this. https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--divide-by-zero

Have you tried using your formula within the sheet itself? I'd also try testing the COLLECT formula without the AVG formula to ensure you are getting data.

Scott Powlus

Thanks, I will try that next.