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)

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

• ✭✭

Thank you Kelly! Spot on.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!