INDEX MATCH Formula with row Hierarchy


I need to reference information from the Digital column and Match it into the Digital Row. The row in white is the Parent column and the rows in grey are the Children. Here is the formula I'm using:

=(INDEX(PARENT(Digital@row), MATCH("Digital", CHILDREN(WO@row), 0)))

In the Parent row the cell is blank, but in the Children row it says #NO MATCH. I know I have to be close I'm just not sure what to try next.

Thank you!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!