Check count by project type AND how many started that month

Hi,

I'm trying to run a formula that would count how many projects were completed in a specific month and the column named "Tier" had the value of "Tier 3" but I can't seem to adapt the below successfully to include both conditions i.e. number of tier 3s completed in Jan

=COUNTIF([Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

=COUNTIF(Tier23:Tier81, CONTAINS("Tier 3", @cell))

Any ideas on what would work here would be greatly appreciated!

Tags:

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @amyk

    This should work to count the completed projects in a month:

    =COUNTIFS(Tier:Tier, "3", [Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

    If you want to include additional data rather than just rows 23-81, you can delete these numbers from the formula to do the whole column to use:

    =COUNTIFS(Tier:Tier, "3", [Actual End Date]:[Actual End Date], IFERROR(MONTH(@cell), 0) = 1)

    Hope this helps!

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @amyk

    This should work to count the completed projects in a month:

    =COUNTIFS(Tier:Tier, "3", [Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

    If you want to include additional data rather than just rows 23-81, you can delete these numbers from the formula to do the whole column to use:

    =COUNTIFS(Tier:Tier, "3", [Actual End Date]:[Actual End Date], IFERROR(MONTH(@cell), 0) = 1)

    Hope this helps!

  • Nick, thank you so much! That worked perfectly, I should have asked 3 hours ago!

    Thanks for also provided the general formula outside of my selected rows :) super helpful!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!