Index/Match - Children

Robert S Fike

How do you use the index/match formula for a child based on the name of the parent.

In the screen shot below. The yellow highlighted area would have the formula looking up who child row is assigned to based on the job # (circled in red).

MedaUser

Hi @Robert S Fike,

Do you have a reference sheet that would be looking up the user to be inserted into the Assigned To column? If so, how is that setup?

Robert S Fike

The reference sheet will have the job # column and assigned to column along with other information columns

Andrée Starå

https://community.smartsheet.com/discussion/133825/index-match-children

Hi,

I hope you're well and safe!

If I understand correctly, you'd need to use the INDEX COLLECT combination instead. Looking for the parent and the row.

Make sense?

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/collect

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!