Link to another sheet and conditionally output

Hello,

I have one sheet that I am trying to link to and output data conditionally.

There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with the LineItem record if the Department is "CF".

Is there a function I can use to bring in this data?

See below for example:

Find more posts tagged with

Sheets

Formulas

Cell linking

Accepted answers

aileenr

I figured it out!

I had to add a row with the LineItem to reference, and a Row Index so it could be pulled down for multiple rows.

=IFERROR(INDEX(COLLECT({WPIDs}, {Dept}, "CF", {LineItem}, $[DND_1055]$1), [Row index]@row), "")

All comments

Bassam Khalil

Hi @aileenr

Hope you are fine, yes you can do that by using Index With Collect function, if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

aileenr

I'm sorry I'm not able to share with anyone outside my company since I have smartsheets on a company laptop

aileenr

I figured it out!

I had to add a row with the LineItem to reference, and a Row Index so it could be pulled down for multiple rows.

=IFERROR(INDEX(COLLECT({WPIDs}, {Dept}, "CF", {LineItem}, $[DND_1055]$1), [Row index]@row), "")

Andrée Starå

Hi @aileenr

Excellent!

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.