Easy way to express Monthly Data

Hi all,

I have started a project to use Smartsheet to track Right First Time across several departments. As part of this I want to track the data on a monthly basis.

The form uses a 'Created date' field to input the date when the entry was submitted.

Is there a way of expressing the date, so I can use it as a COUNTIFS formula?

=COUNTIFS({Site}, "Hay-on-Wye", {Service Area}, "Specifications/Artworks", {Right First Time}, "Yes")

Or have I over complicated it, is there an easy way to show monthly data, without having to use COUNTIFs, "August" for example?

Thanks,

Jack

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

Try this:

=COUNTIFS({Site}, "Hay-on-Wye", {Service Area}, "Specifications/Artworks", {Right First Time}, "Yes", {Date Of Review}, AND(MONTH(@cell) = 8, YEAR(@cell) = 2022))

All comments

Paul Newcome

Try this:

=COUNTIFS({Site}, "Hay-on-Wye", {Service Area}, "Specifications/Artworks", {Right First Time}, "Yes", {Date Of Review}, AND(MONTH(@cell) = 8, YEAR(@cell) = 2022))

Jack Parry

@Paul Newcome Worked! 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.