#UNPARSEABLE using COUNTIF and cross-sheet Reference

10/28/21
Accepted

This feels like a dumb question.

I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothing I've tried is working to correct the issue.

The formula is as follows:

=COUNTIF({Team SCRUM: Communications STATUS Column}Status:Status, "To do")

Any pointers?

Best Answer

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @luke_morales

    It looks like you have the column listed twice... once in the {cross sheet} range, and then again as an in-sheet column reference of Status:Status.

    Try just having the {cross sheet} and the "Criteria", like so:

    =COUNTIF({Team SCRUM: Communications STATUS Column}, "To do")

    Let me know if that worked for you!

    Cheers,

    Genevieve

Answers

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @luke_morales

    It looks like you have the column listed twice... once in the {cross sheet} range, and then again as an in-sheet column reference of Status:Status.

    Try just having the {cross sheet} and the "Criteria", like so:

    =COUNTIF({Team SCRUM: Communications STATUS Column}, "To do")

    Let me know if that worked for you!

    Cheers,

    Genevieve

  • edited 10/29/21

    @Genevieve P. This is fantastic and simple! Solved completely!

    Thank you so much,

    Luke

  • I'm so glad to hear it! I hope you have a good weekend. 🙂

Sign In or Register to comment.