Adding ISTEXT to Formula: Referenced in Other Sheet

Good Day Smartsheet Community:

I am trying to add ISText Criteria to be included if the Column has ACR. Existing Formula Below:

=COUNTIFS({UAT Issue Tracking Sheet Range 2}, DATE(2020, 5, 19), {Issue Tracking Sheet: UAT Range 1}, "High", ISTEXT({Issue / Defect UAT LOG Range 1}), "ACR")

Thanks for All Help In Advance.

Find more posts tagged with

Accepted answers

All comments

Sean Morgan

Hello @Ray B ,

I was able to create a Formula similar to the above that produced the correct output. Rather than using ISTEXT, I just quoted ACR. Please see this below example:

Main Sheet With Data:

Output Sheet:

This was the Formula I used: =COUNTIFS({Cross Sheet 1 Range 2}, DATE(2020, 5, 19), {Cross Sheet 1 Range 3}, "High", {Cross Sheet 1 Range 4}, "ACR")

Let me know if you have any questions.

Regards

Sean

David Joyeuse

Hi Ray!

=COUNTIFS({UAT Issue Tracking Sheet Range 2}, DATE(2020, 5, 19), {Issue Tracking Sheet: UAT Range 1}, "High", ISTEXT({Issue / Defect UAT LOG Range 1}), "ACR")

ISTEXT is a boolean function and here you are using it as a range, which doesn't fit.

Anthony Barthelemy

OK, Thanks! I will try this and let you know how it works.

Thanks Everyone for all your help.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.