Hyperlink to row in another sheet based on a formula

Options

I'm using =Match() to look up a value in another sheet which results in the row number of that sheet. I would like to create a hyperlink in the original sheet that will take me to that row in the 2nd sheet that is displayed based on the match formula.

Example:

Match formula in sheet 1 references row 5 in sheet 2.

Need a hyperlink on sheet one that takes me to row 5 on sheet 2.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!