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.
Linking within Sheet
I know you can use = to link cells within a sheet, but if I needed to link an entire row, is there a way to do that? Or even a couple cells at a time? I tried highlighting all of the cells I need to link & doing a bulk edit sort of thing, but that didn't work. Wanted to ask before I spent an hour linking a million cells together in a sheet. Thanks!
Comments
-
If you are using = to have one cell display another within the same sheet, that is not what Smartsheet calls "linking", It is just a equate formula. Linking is between sheets.
If you go to row 1, column 1 that has a formula, say it is pointing to row 23, column 1
=[Column1]23
If you copy that formula (by copying the cell, not contents of the cell) to another cell, it will update based on the new position.
If you copy that to row 2, column 1, it will now have the formula
=[Column1]24
because it is using "relative referencing"
You can copy that one formula to the rest of row 1 and now row 1 will be showing what is in row 23.
Or you could copy it the the rest of Column1 and it will be pointing to the cell 22 rows below (you probably don't want to do that, since now row 23 is really row 45 which is ...
But you hopefully get the point, just copy and paste them. You can drag-copy too.
Hope that helps.
Craig -
In the sheet you want the row to link:
Highlight those cells in that row, Right Click and select Link to Cell in other sheet
Find the sheet, then select the cells in the row that will be linked
voila
-
Craig!!! Yes!! That's exactly what I needed!!! Thank you, you've just saved me oooodles of time!
Jeff, much appreciated, but was looking to "equate" within the same sheet so Craig's answer did the trick!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives