#DIVIDE BY ZERO

GTN

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

Find more posts tagged with

Formulas

Reports

Dashboards

Accepted answers

Dakota Haeffner

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)

All comments

Dakota Haeffner

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

https://community.smartsheet.com/discussion/comment/322883#Comment_322883

Perfect - Thank you

😀

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.