HELP! How do I modify my formula to separate months and years?

I am separating "Total Monthly Sales," but I need to separate the years as well. For example, our projects were sold in 2021, but carried over into 2022. I need to be able to separate 2022 and 2021.

Here is my formula:

=SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])

Find more posts tagged with

Accepted answers

All comments

Matt Gleaves

Here is my updated formula. I feel like I am close but obviously something is not working correctly.

=SUMIF([Date Awarded]:[Date Awarded], IFERROR(YEAR(@cell), 0) = 2022, [Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])

Genevieve P.

Hi @Matt Gleaves

I've answered you on this other thread:

https://community.smartsheet.com/discussion/comment/347916#Comment_347916

Let me know if you still have questions and I'd be happy to help further!

Cheers,

Genevieve

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.