Days Since Tickets Were Created

Hello,

I need some help with this formula, I am trying to create a datasheet that can pull in tickets from another grid & tell me how many tickets were opened within these timeframes.

30 days ago, 31 - 90 days ago, 91 - 180 days ago over 181 days ago.

I've done similar formulas with this for finding things between dates, but having trouble putting this together. Would appreciate if someone can help and take a look at this?

=COUNTIFS(AND({Priority}, Critical1, TODAY(30){Creation Date} ))

Screen Shot 2022-08-25 at 12.17.36 PM.png

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try this...

=COUNTIFS({Priority}, @cell = Critical1, {Creation Date}, AND(DATEONLY(@cell)>= TODAY(-30), DATEONLY(@cell)<= TODAY()))

RingJake

Thank you @Paul Newcome, this works for 30 days, but could you also alter this formula so it also these other criteria?

Between 30 & 90 Days

Between 91 & 180 Days

Over 180 Days

Paul Newcome

Yes. You would adjust the numbers within the TODAY functions accordingly except for the 180+. In that case you would not need the AND function. You would only need the single criteria set of less than TODAY(-180).

RingJake

Thanks @Paul Newcome , I have the 180 set, however I'm not sure how to phrase this so I get the count in between. Would you be able to provide these ones please?

Between 30 & 90 Days

Between 91 & 180 Days

Paul Newcome

It would be the same as my previously posted formula but you would change the numbers inside of the TODAY functions.

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.