INDEX / MATCH Formula Question

Hello,

I am missing something with executing this formula. This is my first time trying to apply to my sheet. I can only successfully return a #Unparseable error. 😥 Would appreciate any guidance you can provide.

Formula: =INDEX({CI Weight}), MATCH([Task Name]@row, {Project Name}, 0)

Goal: Pull in ranking (CI Weight) from source sheet

Thanks so much in advance!! 🤩

Find more posts tagged with

Accepted answers

Michael Culley

Remove the ) after CI WEIGHT

Marcela Hernandez

My hero!! Muchas gracias, @Michael Culley ! 🤩🤩

Paul Newcome

If you want it to only apply to parent rows then it would look more like this:

=IF(COUNT(CHILDREN([Task Name]@row)) <> 0, INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0)))

All comments

Michael Culley

Missing 1 parenthesis at the end.

Marcela Hernandez

Thanks for your help @Michael Culley. I still get the same outcome, #Unparseable.

Michael Culley

Remove the ) after CI WEIGHT

Marcela Hernandez

My hero!! Muchas gracias, @Michael Culley ! 🤩🤩

Marcela Hernandez

@Michael Culley , using this formula can I add a parent function to it? I would like to apply as a column formula and realizing that there are cells that I don't need this to apply to? When I use =PARENT(INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0))), there's a syntax error.

Paul Newcome

If you want it to only apply to parent rows then it would look more like this:

=IF(COUNT(CHILDREN([Task Name]@row)) <> 0, INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0)))

Marcela Hernandez

Awesome! Thank you @Paul Newcome !! I ended up solving using Ancestor in my formula since the grandchildren were also returning a result, but I like learning this new format as well. 🤩

Paul Newcome

Happy to help. 👍️

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.