Hyperlink to Cell in same Sheet

Hannes Dijkstra

How do I hyperlink a cell in the same Smartsheet?

Find more posts tagged with

Construction

Project Management

Comments

Richard Rymill SBP

Try using the = sign to link one cell to data from another. Double click it and the donor cell is highlighted. Same across one sheet to another.

Hope that helps?

RichardR

Hannes Dijkstra

Hi Richard, I have done that but it does not really do what I want it to do. As per the Hyperlink function to another sheet I want to jump to the cell hyperlinked in the same sheet. The problem with the = is if I link to a cell in say row 1000 from a cell in row 5, I cannot see it?? Thanks for your feedback though ;-)

JohnHinkle

Try using the keyboard shortcut CTRL + G to jump to a row! If you use the =[Cell Ref] function, it will tell you the row number, then use CTRL + G.

Dave B

CTRL G is a cool trick to jump in general, but I agree with Hannes this is a sorely needed feature that's missing.

We have large Excel spreadsheets with all sorts of hyperlinks to places within the spreadsheet; Top, Bottom, Home, and specific cell names as well. Would be a great feature for SmartSheet.

Rodion Emelyan

Kennedy Stomps

Hi Rodion-- I've added your vote!

Brad Jones

+1 vote here too. But also for hyperlinks to cells in other sheets.

I have some macro lists on one sheet that need to have micro lists defined for tracking on another sheet (because of some external scripts). Would love to be able to click on the macro to get to the micro, and vice versa.

Kennedy Stomps

I've added your votes for both of these features, Brad!

KrisWalsh

Greg Johnson

Please add my vote for the above link capabilities as well

Katye Reed

Tried your solution and it worked! It be great if this was a feature part of Smartsheet rather then having to do the tedious work of applying this formula across multiple columns.

Andrée Starå

Hi,

I have a workaround that might help.

Create a Table of content section in the sheet (at the top)
Create a new column (Count)
Use the following formula in the Count column.

=1 + 0 (Copy down the whole sheet)
Create a new column (RowID)
Use the following formula in the RowID column, cell 1. =COUNT(Count$1:Count@row) (Copy down the whole sheet)
Create a new column (Row)
Use the following formula in the Row column.

="CTRL/CMD+G " + RowID@row
Link the different sections of the sheet to the ToC in the at the top with the following formula. =Row16 (for row 16)
Try it by pressing the CTRL/CMD + G combination and type the number from the ToC section that you want to jump to.
You can also combine the Row and Task Name column and hide the Count, RowID and Row columns.

Please see the attached link/screenshot for more information.

https://cl.ly/d71b0a

Depending on your country you’ll need to exchange the semi-colon to a comma in the above formulas.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jason Apol

Please add function to click a cell with a link in row X that zips the clicker to row Y.

Necessary for organization on the sheet and bringing a viewer easily to relative content. Ctrl-G isn't user friendly enough.

Thanks!

Jason Apol

Good idea, but only effective if the destination cell is visible on the screen. Meaning if you click on cell b10 and the destination is d200, you won't see d200.

Of course with the double click you will see the formula to d200 and can then scroll there. Not elegant, but gets you to your data.