Help with Index Match bringing back Children row data based on Parent Row Match

Jeana
Jeana ✭✭✭✭✭✭

How do I get Index/Match to do the following:

Look at Source sheet column for a Match in a Parent row and if there is a match, pull in two date columns for all the CHILDREN.

This formula is pulling in dates but only for the first PARENT/CHILD section. It's not checking the MATCH on the Parent Asset #.

=INDEX(COLLECT({Test AMT Task Started}, {Test Parent}, PARENT([Deliverables and Tasks]@row), {Test AMT Asset/Tasks}, [Deliverables and Tasks]@row), 1)

This formula say's Unparseable.

=(INDEX(COLLECT({Test AMT Task Started}, {Test Parent}, PARENT([Deliverables and Tasks]@row), {Test AMT Asset/Tasks}, [Deliverables and Tasks]@row), MATCH(PARENT({Test AMT Asset #}, {Asset #}, 1))))

Thanks!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!