Can Index Match pull over a hyperlink in a Children row?

Jeana ✭✭✭✭✭✭
edited 08/25/21 in Smartsheet Basics

I'm using this formula to pull info from one sheet to another based on an Asset #. One of the fields I'm pulling has a hyperlink in it. This seems to work on some rows but not others. Here's the formula:

=INDEX({Asset Catalog Range 3}, MATCH([Asset #]@row, {Asset Catalog Asset #}, 0))

This formula woks for this row (see pic).

This formula doesn't bring back anything for the Children row in Step 1

=INDEX({Process Steps Step 1}, MATCH([Asset Type Steps]@row, {Process Steps Asset Item}, 0))

Any ideas?

Best Answer