How to populate Row Link (from Row Properties) as a reference on a different sheet?

Options

I have a column in a target sheet where I manually insert the Row Link (from Row Properties) to the corresponding row in my source sheet. I'm usually interacting with my data in the target sheet, so using that link helps me quickly find the exact place in the source sheet where I can make edits and keeps both sheets in sync.

Is there a way to create a sheet reference that will automatically pull in the URL from the Row Properties based on a unique identifier? I'm wanting it to work like INDEX-MATCH, but that only allows me to reference columns or cells.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!