Linked Cells Don't Match

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
    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


    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

  • kelceyg
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!