IFERROR

Can anyone help me with an IFERROR formula please to get rid of the #DIVIDE BY ZERO message. I've tried several example off the internet but just keep getting incomplete argument or imparsable messages

This is the formula i have that returns the error message

=IF([Completion Date]@row = "", ROUND([DAYS SINCE START DATE]@row / [TOTAL DAYS]@row * 100, 0), "COMPLETE")

Thank you

Find more posts tagged with

Accepted answers

Paul Newcome

You would wrap the whole thing like so:

=IFERROR(original_formula, "")

All comments

Paul Newcome

You would wrap the whole thing like so:

=IFERROR(original_formula, "")

Fialko66

https://community.smartsheet.com/discussion/comment/334469#Comment_334469

Morning Paul

Thank you so much, after messing for ages this worked right away. Thank you again for your help

Barry

Fialko66

https://community.smartsheet.com/discussion/comment/334572#Comment_334572

I wasn't closing the original formula before putting the ,"") but adding the ,""then closing everything with 2 sets of brackets ,""))

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.