Date Report | Partner CBO Name |
|---|
01/12/25 | Children's org |
05/15/25 | Foodbank |
08/30/25 | Children's org |
09/11/25 | Chamber |
11/25/25 | Digital Bus |
08/21/24 | Digital Bus South |
01/15/26 | Children's org |
01/12/24 | Foodbank Sister |
02/15/24 | For the children org |
07/01/26 | Digital Bus #2 |
08/05/26 | Family Center |
12/01/26 | Family Center |
I am trying to come up with a formula that counts distinct names from a column based on a date range on another grid view but I've tried a few routes with no luck this week. Semi new to the SmartSheet game, thanks for your help!
Formula that hasn’t worked:
=COUNTIFS(Date Report}, >=DATE([YearReporting]@row , 1, 1), {Date Report}, =<DATE([YearReporting]@row , 12,31),DISTINCT({Partner CBO Name}))
