Cell Reference Within Same Sheet Not Working


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!