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?
Thanks!
Brad
Best Answers
-
Boy. I am not sure that is possible. You could reference the cell, but there is no way to link to a cell in a sheet.
-
Hello Smartsheet Users,
Yes, cell linking within the same sheet (unfortunately) is not available as a feature yet and I would certainly recommend submitting this as an idea but in the meantime, you can achieve similar functionality using the below options -
1. Formulas:You can use a formula to reference the cell in the same sheet. For example,
=[column name]n
wheren
is the row number.2. Row Links:You can create a link to the row containing the cell you want to reference. This can be done by right-clicking the row, selecting "Properties," copying the "Row Link," and pasting it into another cell.
Hope this helps!!
Ipshita :)
Ipshita Mukherjee
Answers
-
Boy. I am not sure that is possible. You could reference the cell, but there is no way to link to a cell in a sheet.
-
@Mike Wilday That is what I was afraid of. Thanks for your input!
-
@Bradhickswa Unfortunately, as of now, Smartsheet does not allow to link a cell within the same sheet but I would like to add that it would be a great feature if we can get that, so this is a message out to the whole community. We also need to link in cells within the same sheet and as of now unable to do so. I vote up to add this as a feature.
Ipshita Mukherjee
-
This feature's been asked for years, it is a bit of a shame that it hasn't been implemented already
-
Hi @Bradhickswa & @Ipshita & @albferra
I hope you're well and safe!
To add your vote.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Being able to jump around a sheet without having to scroll, and scroll, and scroll, and scroll would be a great improvement.
-
Bummer. Came here for the same question.
-
This would be a very useful feature because many times tasks are related to one another. Surprised this isn't already implemented.
-
How is this not a feature of a sheet that does calculations? I mean, this is crazy!
-
You can do it, the only downside is it will open in another tab
-
Is it in a different linking interface? I can only select different sheets when I try to link data.
-
Hello Smartsheet Users,
Yes, cell linking within the same sheet (unfortunately) is not available as a feature yet and I would certainly recommend submitting this as an idea but in the meantime, you can achieve similar functionality using the below options -
1. Formulas:You can use a formula to reference the cell in the same sheet. For example,
=[column name]n
wheren
is the row number.2. Row Links:You can create a link to the row containing the cell you want to reference. This can be done by right-clicking the row, selecting "Properties," copying the "Row Link," and pasting it into another cell.
Hope this helps!!
Ipshita :)
Ipshita Mukherjee
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives