Can you cell-link within the same sheet?

My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a workspace, but we want to create a quicker way to find information within the same sheet without having to scroll or create a bunch of filters (as that could get confusing). Has anyone come across this before, and have a solution or a work-around?



Best Answer