I want to count how many tickets the Assigned to group Business Systems received in January

I am trying to count the amount of tickets the Business Systems teams received in January. There are other teams in other rows.

The formula I tried was:

=COUNTIFS([Assigned Team]:[Assigned Team], @cell = "Business Systems"), @cell <= TODAY(), [Assigned Team]:[Assigned Team], @cell > TODAY(-30))


Answers

  • heyjay
    heyjay ✭✭✭✭✭
    =COUNTIFS(
    [Assigned Team]:[Assigned Team],"Business Systems",
    [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = 1)
    

    Where 1 represents the month in sequence.

    ...

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!