nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Count tickets created in a specific month

Jona_g28

Hello all,

I am trying to setup a formula for all closed tickets based by month. I tried to make this formula below work but it's giving me a 0 count. Can someone please help? My criteria is for the ticket to be closed and to fall under a certain month.

=COUNTIFS({All Tickets Range 1}, "Closed", {All Tickets Range 2}, "MONTH(@cell) = 7")

Any help is very appreciated

Find more posts tagged with

Accepted answers

Paul Newcome

Try removing the quotes from around the second criteria.

All comments

Paul Newcome

Try removing the quotes from around the second criteria.

Jona_g28

Did that already, not sure why it is not working

Andrée Starå

Hi @Jona_g28

I hope you're well and safe!

Do you get an error message?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Are you able to tprovide some screenshots for reference? If they include rows that meet the criteria of the formula, that would be ideal.

Jona_g28

@Andrée Starå no error message, just a 0 as the answer

Jona_g28

@Paul Newcome , I logged out and logged back in after removing the quotes. It's working now.

Thanks to both!

Paul Newcome

Happy to help. 👍️

Andrée Starå

@Jona_g28

Excellent!

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.