Cell Reference Within Same Sheet Not Working

Marek Regulski

Hi

I want to reference column "Start Date" in the column "End Date". I want the formula in "End Date" to be =Start Date15+5 (add 5 days to start date). However, for some reason it is not working. I am using this in the Gantt tracker.

Do you have any idea how can I make it work? I have noticed that I am not able to reference any cell within this sheet. Moreover, the cells are not highlighting, so if I start typing with "=" and then I move arrow to highlight cell, it is just switching to another cell - not creating a link/connection to the other cell.

Paul Newcome

You cannot use formulas in columns that are being used by the dependency settings. You would need to use predecessors instead.

Paul Newcome

You cannot use formulas in columns that are being used by the dependency settings. You would need to use predecessors instead.