Counting column based on date and department
I am trying to sum the number of rows that fall in a certain date period and based on department
This is what I came up with but it just returns 0's, Should I be using a different formula like COUNTIF?
=SUMIFS(Department:Department, [Week Ending]:[Week Ending], >=TODAY(-5), Department:Department, "Tech Unit D")
Answers
-
I was able to figure it out by moving to a COUNTIFS
=COUNTIFS([Week Ending]:[Week Ending], >=TODAY(-7), Department:Department, "Tech Unit D")
-
Hi @TLaGrant
I hope you're well and safe!
Excellent! Glad you got it working.
I almost always use COUNTIFS, even if it's only one criterion.
I hope that helps!
Have a fantastic week & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!