I'm trying to grab name from a row on a separate sheet where the row matches two criteria.

I'm trying to grab a name from a row on a separate sheet where the row contains "Completed" and the same part number.

Here is the equation I'm attempting to use but get "UNPARSEABLE"

=INDEX({Employee Name Column}, COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column}, "Completed"))

1st Page Below is where the equation originates.

Second Page is where I'm trying to match the part number to the first page and populate completed by with the employee who completed the part.

Ideally I would be able to add multiple names if two employees completed the same part.

Thanks

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Christian Graf

Hope you are fine, please try the following formula and convert it to column format formula:

=IFERROR(JOIN(COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column}, "Completed"), " / "), "")

Data Sheet Screenshot

Formula Sheet Screenshot

All comments

Bassam Khalil

Hi @Christian Graf

Hope you are fine, please try the following formula and convert it to column format formula:

=IFERROR(JOIN(COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column}, "Completed"), " / "), "")

Data Sheet Screenshot

Formula Sheet Screenshot

Christian Graf

Hi @Bassam Khalil

That worked pefectly!

Thank you so much!

Bassam Khalil

@Christian Graf

Excellent, I will be happy to help you anytime

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.