Adding a link to specific row on a sheet
I have a sheet that has hundreds of rows and want to add an anchor type link to the top of that sheet so that I can easily go to a specific row within that sheet. Can someone help me with this?
Comments
-
This feature is not available in Smartsheet.
With the Sheet, Ctrl+G is the go-to command, but you need to know the row number you want to go to and this can not be embedded in a cell or formula.
I suggest you submit an enhancement request (using the link to the right)
Craig
-
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.
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
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.
-
Select the row of interest, Properties, Copy Link.
Post he link wherever you need.
When needed click on it, and WAIT. At least in my case (500 rows and 124 columns) nothing will happen until 40 sec later. Then suddenly the row will be selected automatically
-
That doesnt open up a form tho. Is there a way to to make it an update request link
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 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