How to use INDEX(MATCH()) when I have multiple children/parent relationship?

Basically I'm trying to use index(match()) formula as a way to grab data from one template and use in another.

They are very similar but one does not have the row information required, since it is in a parent/children relation. Example:

Project Name

Project Phase

To use the formula, I would need to use the relation as: Project Name+Project Phase (as if it was Concatenate).

It would result in something like this:

=INDEX({Tech Deliverables - Collect Intervalo 1}; MATCH([Project - Wave]59; {Tech Deliverables - Collect Intervalo 2}; 0))

Any help? If more detail if required, I'll be happy to provide at some point.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!