COUNTIFS with Date range with @row
I have the current formula that counts the start date but I wanted to see if i could do a range of dates from start date to end date and count those. Any Advice?
=COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], [Start Date]@row)
Best Answer
-
Hello @Christopher Neal
It looks like you would be looking for something like this:
=COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], >=[Start Date]@row,[End Date]:[End Date],<=[End Date]@row)
This would return the number of records for the Staff Team of that row; that have a Start Date >= the Start Date of that row, and an End Date >= the End Date of that row.
Hope this helps!
Let me know if I have misunderstood your question!
Cheers~
Krissia
Answers
-
Hello @Christopher Neal
It looks like you would be looking for something like this:
=COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], >=[Start Date]@row,[End Date]:[End Date],<=[End Date]@row)
This would return the number of records for the Staff Team of that row; that have a Start Date >= the Start Date of that row, and an End Date >= the End Date of that row.
Hope this helps!
Let me know if I have misunderstood your question!
Cheers~
Krissia
-
That worked perfectly thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!