Formula referencing another worksheet

H.L.Dixon2021

Hi, I am trying to create a formula to determine how many tickets are in a Category and have a due date within the next 30 days. I am trying to do this outside of the worksheet so when creating my formula I need to reference back to this sheet, however no matter what I try I'm still having the same issues...

=COUNTIFS({2022 JIRA/Analysis Report Request Tracker Range 1}, "ROI Analysis Report", {2022 Report Request Tracker Range 2}, AND({2022 Report Request Tracker Range 2}, >=TODAY(), {2022 Report Request Tracker Range 2}, <=TODAY(+30)))

Heather Duff

Hi @H.L.Dixon2021 ,

Try this:

=COUNTIFS({2022 JIRA/Analysis Report Request Tracker Range 1}, "ROI Analysis Report", {2022 Report Request Tracker Range 2}, @cell>=TODAY(), {2022 Report Request Tracker Range 2}, @cell<=TODAY(+30))

Since you are using COUNTIFS, you don't need the AND.

Hope this helps! Let me know if it works.

Best,

Heather

H.L.Dixon2021

You're amazing! Thank you for such a quick response! You saved my deadline :)

Heather Duff

@H.L.Dixon2021 Happy to help! Have a fantastic weekend.