Countifs for items completed YTD by quarter?


Hi everyone, first time poster here.

I need a formula that will count Buy closings YTD by quarter.

The best guess I have after reading other posts is:

=COUNTIFS([Buy close date]:[Buy close date], > DATE(2021,01,01), [Buy close date]:[Buy close date] < TODAY, [Closing Q]:[Closing Q], Q1)

It's not working but I can't quite piece together where I'm going wrong. Any tips or tricks?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!