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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 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
 304 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!