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:[email protected] | 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
Check out the Formula Handbook template!