Tabulation formula

Trying to create a formula to track the number of instances a specific cell value occurs within a given month.

Relevant columns are "Publish Date" and "Partner ID" and I need to tabulate how many times the Partner ID value "RNO" occurs within a given month.

Here's what I have so far (from the template), which renders the number of rows per month, but I can't get it to count the number of times Partner ID is RNO within that range.

=COUNTIFS([Publish Date]:[Publish Date], IFERROR(YEAR(@cell), 0) = 2023, [Publish Date]:[Publish Date], IFERROR(MONTH(@cell), 0) = 1)

Find more posts tagged with

Accepted answers

Kelly Moore

Hey PWM

Will this work?

=COUNTIFS([Publish Date]:[Publish Date], IFERROR(YEAR(@cell), 0) = 2023, [Publish Date]:[Publish Date], IFERROR(MONTH(@cell), 0) = 1, [Partner ID]:[Partner ID], "RNO")

I wondered if RNO is part of a longer string? If yes, then try this. CONTAINS can be used when you are searching for potentially part of a word or textstring.

=COUNTIFS([Publish Date]:[Publish Date], IFERROR(YEAR(@cell), 0) = 2023, [Publish Date]:[Publish Date], IFERROR(MONTH(@cell), 0) = 1, [Partner ID]:[Partner ID], CONTAINS("RNO",@cell))

Kelly

All comments

Kelly Moore

Hey PWM

Will this work?

=COUNTIFS([Publish Date]:[Publish Date], IFERROR(YEAR(@cell), 0) = 2023, [Publish Date]:[Publish Date], IFERROR(MONTH(@cell), 0) = 1, [Partner ID]:[Partner ID], "RNO")

I wondered if RNO is part of a longer string? If yes, then try this. CONTAINS can be used when you are searching for potentially part of a word or textstring.

=COUNTIFS([Publish Date]:[Publish Date], IFERROR(YEAR(@cell), 0) = 2023, [Publish Date]:[Publish Date], IFERROR(MONTH(@cell), 0) = 1, [Partner ID]:[Partner ID], CONTAINS("RNO",@cell))

Kelly

PWM

https://community.smartsheet.com/discussion/comment/358980#Comment_358980

Thank you Kelly! Spot on.

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.