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?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!