Finding duplicated unique IDs within a certain year

Options

Hello,

I have a list of unique IDs that I would like to count how many times they occur during the year. I am trying to use the unique ID column and the year the job was filed to get a summary of how many times that unique ID was found annually? Any help would be greatly appreciated

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!