I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?

I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET.

=COLLECT({2024 All Projects}, {2024 Branches}, {2024 Branches} = Branches@row)

How can I get my criterion and criterion range to do what I want?

TIA

Find more posts tagged with

Formulas

collect

Accepted answers

All comments

Paul Newcome

What do you plan to do with the data? The COLLECT function has to be nested inside of another function.

Mark.poole

All the ranges {2024 All Projects}, {2024 Branches}, and {2024 Branches} must have the same number of rows. Mismatched row counts cause the #INCORRECT ARGUMENT SET error.

TBurnett

I just want to move it. I have it joined like I want in another sheet, but I'm struggling to get everything moved and then combined in a helper sheet. When I try and just link the cells it links the formulas and gives me errors because the needed info isn't in the new sheet.

I have 3 pieces of data from each year, with each year having its own sheet. I collected and joined them in the year sheet, but now I can't get them where I want them. I feel like this is a ridiculously simple problem.

@Paul Newcome @Mark.poole

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.