Linked Cells Don't Match

kelceyg

Hello! I am attempting to link cells (Duration, Start, Finish) from a project's sheet to a master sheet. However, once I link the cells, the Finish date is different on the master sheet than what has been entered in the project's sheet.

Cells in project sheet:

Cells in master sheet:

The Finish date should be 1/2/23, not 4/26/23. Why is this happening and what do I need to do to fix it?

Kaveri Vipat

Hi kelceyg,

This could be possible because of the Project Setting in your sheet, due to this it updates the Finish date according to the Duration. 

Kaveri Vipat, Smartsheet Engineer, Ignatiuz Software

kelceyg

My understanding is that the duration is automatically calculated based on the Start and Finish dates? This is the only project where the Finish date is not matching what is in the project plan.

AMarie91

Hi, was a resolution found for this? Or is there a better way to link to show the date? I am running into same issue and cannot find a fix.