COUNTIFS formula not calculating correctly in 3 of 4 columns- I'm at a loss

Kari G
Kari G ✭✭✭✭
edited 03/13/24 in Formulas and Functions

What is wrong with my formula? I need it to return the number of times it finds a certain answer from a drop down list for a specific facility between 2 dates. The dates we are searching are from the first of the current month through yesterday. Ex. if it's March 13, 2024, I'm looking for data between March 1, 2024-March 12, 2024. I am referring across sheets.

This is my current formula

=COUNTIFS({PT Sat Surv Range 1 - Facility Name}, [Primary Column]@row, {Patient Satisfaction Survey Reason}, "Yes", {PT Sat Surv Range 1 - Date Created}, AND(MONTH(@cell) = MONTH(TODAY()), YEAR(@cell) = YEAR(TODAY()), @cell < TODAY()))

I'm not getting an error message, I'm getting an incorrect number, sometimes too high and sometimes too low. We have been working on this for weeks.

HELP! 🤯😰🤪


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!