Cell Linking

ejacksonBPT

Can you do cell linking within the same sheet?

KPH

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:

KPH

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.

ejacksonBPT

Its not calculating/populating. I hit enter and what I typed is there.

ejacksonBPT

KPH

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:

ejacksonBPT

Amazing! that worked! Thank you so much!

KPH

Great news!

ejacksonBPT

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

KPH

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.

ejacksonBPT

hmmm that didn't work, I'll need to play around with this some more. thank you.