Tabulation formula

PWM

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)

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

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.