#DIVIDE BY ZERO

Hi, I have a Smartsheet with calculated columns like -

=SUM(Open@row / SUM(Open@row:[Past Due]@row))

The Smartsheet is being used to create Donut graphs on a Project Dashboard.

In the example above;

Open = 0

In Progress = 0

Closed = 0

Past Due = 0

rather tan getting 0%for Open, I get

#DIVIDE BY ZERO

How do I resolve this?

i.ie 0 divided by 0 = 0%?


Thank you

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!