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
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Posts
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…
