Counting Referrals by Week

Courtney Coules

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)))

Jeff Reisman

@Courtney Coules

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.)

Jeff Reisman

@Courtney Coules

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.)

Courtney Coules

Thank you so much!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/364047#Comment_364047

You're quite welcome! If you could mark my answer as accepted, that would be great!