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.

Answers

  • 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
    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
    Anthony Barthelemy ✭✭✭✭✭✭

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

    Thanks Everyone for all your help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!