INDEX / MATCH Formula Question

Marcela Hernandez

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!! 🤩

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)))

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. 👍️