#UNPARSEABLE using COUNTIF and cross-sheet Reference

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. Employee
    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!