count how many times a "Department Name" comes up with completed date
Comments
-
Hi Mark,
This will do what you're after:
=COUNT(COLLECT([Completed Date]:[Completed Date], [Department Name]:[Department Name], "Department Name"))
Kind regards,
Chris McKay
-
Awesome, Thanks Chris You Da Man!
-
My pleasure
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!