Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Hyperlink to a specific row in another sheet?
Comments
-
See, this kind of thing drives me crazy. This functionality is clearly available, it's just not user-friendly at the moment. Please add my vote for an easy way to hyperlink to a specific row in another sheet. Ain't nobody got time to email themselves each individual row!
-
Can you explain a littler further how to do this exactly?
-
Right click on the cell that you want to be the host. Example:
Go To Cell B5 on page # 3
Right click like you normally would to create a hyper link.
On the right side of the pop up box choose "Book Marks"
Type the Cell Reference " I want the link to go directly to cell B5 on page #3" so enter B5. Below that should be a listing of all your excel pages. Click on the page that has the cell B5 that you want to connect to.
-
Cjaythomas - this looks like info for Excel not Smartsheet. I believe the original question was asking for this function within Smartsheet.
Blessings,Loann
-
I was also looking at this and you can link to a specific row by using the 'row link'. You can find this by looking at the properties of the target row you want to link to.
-
That works:
- Right click to left of row you want to link to
- select Properties
- copy row link
- open new tab with the sheet/row you want to link from
- right click in row
- create hyperlink
...but quite a few steps though.
I imagine it should work more like the "link from cell in other sheet' and it can cut out a few steps and keep you working in the same sheet instead of opening another tab:
- Right click in cell
- select Link From Cell
- select sheet
- then select row
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives