Linking within Sheet

Mel G

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!

J. Craig Williams

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