#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?

Find more posts tagged with

Formulas

Support

Accepted answers

Genevieve P.

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

All comments

Genevieve P.

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

luke_morales

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

Thank you so much,

Luke

Genevieve P.

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

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.