#DIVIDE BY ZERO

GTN · 03/16/22

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

Dakota Haeffner · 03/16/22

I've found IFERROR to be helpful for those types of errors.

Try this formula here:

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

Dakota Haeffner · 03/16/22

I've found IFERROR to be helpful for those types of errors.

Try this formula here:

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

GTN · 03/16/22

Perfect - Thank you

😀

Best Answer