#DIVIDE BY ZERO

Hi, I have a Smartsheet with calculated columns like -

=SUM([email protected] / SUM([email protected]:[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