Formula referencing another worksheet
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)))
Answers
-
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
-
You're amazing! Thank you for such a quick response! You saved my deadline :)
-
@H.L.Dixon2021 Happy to help! Have a fantastic weekend.
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!