Help w/COUNTIFS, UNIQUE and specific year

jmo ✭✭✭✭✭✭

Hi team - I have a sheet with a column called "Agreement Number" that I normally look down to get a unique count of agreements using: =COUNT(DISTINCT({(Source Data) Agreement number}))

I now have data that I've placed in that sheet in 2020 and 2021. What I'd like to do is count the unique agreements in the "Agreement number" column that were created in 2021. Created is an auto generated date.

Any ideas on how to go about that?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!