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

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.