Counting Referrals by Week
I am trying to count incoming referrals based on the date of the referral. I have this so far, but it isn't correct yet:
=COUNTIF({OBOT Referrals Date Referral Received}, (@cell >= DATE(2023, 1, 1)), (@cell < DATE(2023, 6, 1)))
Best Answer
-
Try changing the function to COUNTIFS and throwing an AND function in there:
=COUNTIFS({OBOT Referrals Date Referral Received}, AND(@cell >= DATE(2023, 1, 1), @cell < DATE(2023, 6, 1)))
Alternatively, you could use COUNTIFS, and use the range twice, once for each date criteria:
=COUNTIFS({OBOT Referrals Date Referral Received}, @cell >= DATE(2023, 1, 1), {OBOT Referrals Date Referral Received}, @cell < DATE(2023, 6, 1)))
(When structured this second way, the AND is built into the COUNTIFS function, because all the criteria have to be true in order for the row to be counted.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Try changing the function to COUNTIFS and throwing an AND function in there:
=COUNTIFS({OBOT Referrals Date Referral Received}, AND(@cell >= DATE(2023, 1, 1), @cell < DATE(2023, 6, 1)))
Alternatively, you could use COUNTIFS, and use the range twice, once for each date criteria:
=COUNTIFS({OBOT Referrals Date Referral Received}, @cell >= DATE(2023, 1, 1), {OBOT Referrals Date Referral Received}, @cell < DATE(2023, 6, 1)))
(When structured this second way, the AND is built into the COUNTIFS function, because all the criteria have to be true in order for the row to be counted.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you so much!
-
You're quite welcome! If you could mark my answer as accepted, that would be great!
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!