Formula Help Part 2

Lchicklis ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi there,

I would like to count all of the projects in my portfolio that are launching in Jan, in Feb, in March, etc. I have a Date column called Upcoming Launch Date. 

I posted previously and received this formula which works (January example):

=COUNTIFS([Upcoming Launch Date:Upcoming Launch Date], IFERROR(MONTH(@cell), 0) = 1)

What I later realized is that I would only like to count only those upcoming launch dates that are in January 2019. I have projects for each month that launched last year that I do not need in my calculation.

Hoping someone in the community can help!

Thanks so much,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!