COUNTIF the values is lesser than today's date

Hi Folks,

I would like to count the names with respective to dates in another column which is lesser than today's date.

I used the below formula:

=COUNTIFS([Projected CM1]:[Projected CM1], <=TODAY(), [CM1]:[CM1], "Flextronics Wuzhong CM")

But it doesn't give the right result, any leads please advise




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!