Tabulation formula

PWM
PWM ✭✭
in Formulas and Functions

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)

· Share on FacebookShare on Twitter

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!