Index/Match to return a Row URL in another sheet?

Amanda Merrigan

Anyone know if it's possible to show a Row URL in a cell in another sheet using Index/Match (similar to how a report shows a hyperlink to the row url in the sheet name column).

ie - =INDEX({ROW URL}, Match(Info@row, {Info}, 0)). I'm not sure how to get the ROW URL into the Reference or if you even can.

Paul Newcome

Reports only show a link to the sheet. Not a specific row. To be able to do this, you would need to leverage the API or a third party application.

Amanda Merrigan

Thanks @Paul Newcome

if you click on the hyperlink in the sheet name column on a report, it actually brings you right to the row in the sheet where the data is coming from. I do it everyday! It’s a great feature that I was hoping we could incorporate on the sheet level.

Paul Newcome

Oh. Well that's interesting. It has been a while since the last time I used that feature, so I didn't realize it was so specific now!

Even still... You would need to leverage the API or a 3rd party app to be able to do this outside of a report.