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?

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.