Count Days Since Ticket Opened

Hello,

Needing to calculate number of days since line item appeared when Date Submitted column is "Auto-Number/System Generated Column Created (Date)" -- and then display "Closed" when Checkbox is checked in Complete column. Can't get the "Complete" to appear -- just goes blank.

=IFERROR(IF(Complete@row = 0, TODAY() - [Date Submitted]@row), "Complete")

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

That is because you are not specifying what should happen when the IF statement is not true (complete is checked). If you do not specify that, it defaults to a blank output. Since there IF statement is not outputting an error, the IFERROR is not going to output the "Complete". Try this instead:

=IF(Complete@row = 0, TODAY() - [Date Submitted]@row, "Complete")

All comments

Paul Newcome

=IF(Complete@row = 0, TODAY() - [Date Submitted]@row, "Complete")

Bessie Koch

Perfect! Thank you!

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