Adding ISTEXT to Formula: Referenced in Other Sheet

Anthony Barthelemy

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.

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.