nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Adding a link to specific row on a sheet

WSadmin2

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?

Find more posts tagged with

Cell linking

Comments

J. Craig Williams

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

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

Ford

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

Victor Sauceda

https://community.smartsheet.com/discussion/comment/156931#Comment_156931

That doesnt open up a form tho. Is there a way to to make it an update request link

Sign in to join the conversation!

Quick Links

Trending discussions

FORMS | Make 'Send me a copy of my responses' to be View Only
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
Automation
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
New Dashboards
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…