Pulling Names into Another Sheet

Hello,

I am attempting to pull "In Progress" Partners into another sheet as an entire column, the purpose of this would be to create a datasheet on "In Progress Partners" who are associated to different stages of the Project.

In the picture below I am pulling Partners with the right criteria, but I am hoping to create his as a column formula were the true list of Partners is added rather than just the same one being repeated.

Screen Shot 2021-08-17 at 10.34.43 AM.png

Additionally, I one want the Parent cells to be included in this Index Match, so I would like this to be the result of an IF statement referencing if the box is checked from the master tracker as well.

Screen Shot 2021-08-17 at 10.37.18 AM.png

I think I'm getting closer, but am running into problems here, can somebody please help me with this?

Thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

Andrée Starå

Hi @RingJake

I hope you're well and safe!

I'd recommend adding an auto-row number to the master sheet and adding a column where you add the numbers manually in the other sheet and connect the information.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

RingJake

Hey @Andrée Starå, I don't think thats quite the answer I'm looking for as I am trying to make this as automated as possible and it seems the Index Match function could work if done the right way?

RingJake

I have gotten this to work slightly using this formula.

=IF({If Parent Row} = 1, INDEX({Partner Name}, MATCH("Not Started", {Status}, 0)), "false")

However, it seems graphs cannot take information being used from an Index Match? Can this please be confirmed?

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.