Date use with COUNTIFS formula (Non-Specific Date)

Matt Travis
Matt Travis ✭✭
edited 03/31/21 in Formulas and Functions

I have set up a summary grid pulling information from another Support calls grid so I can keep track of logged calls completed by members of my team. I am currently using the formula below to pull that information for one of the team and it works fine.

=COUNTIFS({Support calls Range 1}, "Complete", {Support calls Range 2}, "Fred")

The query I have is because I want to improve this. I would like to apply this to record only those calls completed in the current month and a second data set for only the current year. What would be the best way to accomplish this? I've only seen things for specific date ranges used so far which wouldn't be suitable for me.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!