Count Projects by Year within a range

Hi All!

I've been scratching my head with a way to count all projects where the Start Sate or End Date have a year that matches a bucket.

Fore example, if a project's start date is 2020 or end date is 2020, then I need to count it in the 2020 sheet summary. A project where the start is 2019 and end is 2020 would also be added, and the same case for a project with the start of 2020 and end of 2021.

I've been trying to do this with a combination of countifs and ors, but coming up blank. Any suggestions? Thanks!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!