Cell Linking
Can you do cell linking within the same sheet?
Best Answer
-
It looks like you may have a ' at the start of your formula so the sheet treats it as text and not a formula.
The first example is also missing the space between Due and Date
The second should have the $ outside of the square brackets
=$[Due Date]$4
Try going to a new cell, making sure it is blank, typing the = and then clicking on the cell that you want it to reference. That will fill in the column name and row number and prevent typos. You can then add the $ if needed.
It should look like this:
Answers
-
You cannot use the "Link from Cell in Other Sheet" option to bring in data from the same sheet, but you can reference the cell in the same sheet using =[column name]n where n is the row number.
If you include a $ before the column name or before the number the reference is fixed so you can drag the formula to other cells and retain the same column/row.
-
Its not calculating/populating. I hit enter and what I typed is there.
-
-
It looks like you may have a ' at the start of your formula so the sheet treats it as text and not a formula.
The first example is also missing the space between Due and Date
The second should have the $ outside of the square brackets
=$[Due Date]$4
Try going to a new cell, making sure it is blank, typing the = and then clicking on the cell that you want it to reference. That will fill in the column name and row number and prevent typos. You can then add the $ if needed.
It should look like this:
-
Amazing! that worked! Thank you so much!
-
Great news!
-
sorryโฆso your fix worked in my test sheet but its not working on my real sheet and I don't know why.
I see the ' but I'm not sure why its there. The column is set up as a date
-
The ' is usually added to make numbers appear as text (so they retain the leading 0) or formulas appear as text (so you can see them). It could be the result of a sheet being imported from another format. If you delete the ' and start with an = the formula will be treated as a formula.
-
hmmm that didn't work, I'll need to play around with this some more. thank you.
Help Article Resources
Categories
Check out the Formula Handbook template!