Question on Cross Sheet Formula

Hi,

I am trying to write a cross sheet formula that pulls a list of tests for a manufactured item for a specific project and keep running either into an Argument error or UNPARSABLE error:

I have tried the following iterations of the formula:

=INDEX(COLLECT({Individual testing assignments Range 1},{Individual testing assignments Range 2} HAS({Batch Summary sheet Range 2}, {Individual testing assignments Range 2})))

The intent of the formula is to pull all of the testing requirements: {Individual testing assignments Range 1} for the manufactured items called out in {Batch Summary sheet Range 2}.

Where {Individual testing assignments Range 2} and {Batch Summary sheet Range 2} are matching columns.

Any help would be greatly appreciated!

Find more posts tagged with

Accepted answers

All comments

Will Jeffords

Hi @Steve Gaertner , is it possible that you are just missing the comma that should be between "…Range 2}, HAS…" in your formula above? I didn't test, but I know that formula won't work as pasted above :)

Let me know!

Will

Steve Gaertner

Thanks for check, that fix returned an incorrect argument set error.

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.