Copy Start and End Dates (& Predecessors) from another sheet

Can this be done?

I have a project plan, and I want to pull over Start and End dates from another project plan. Predecessors, too. I tried typing a formula in the Start Date cell to link to the corresponding State Date in the other plan, but it doesn't seem possible.

Does anyone have any creative ideas on how to pull this off? Is it even possible?

Find more posts tagged with

Formulas

Accepted answers

MarceHolzhauzen

Hi @Berto_DA

You will not be able to add formulas to those columns as they work with the project settings in your sheet.

How about creating an automation that copies your entire row from one sheet to the next, that way the entire row will copy over. This is a once off move though as it will not sync back to the original sheet.

IF you need this to be synced, you might have to create helper columns in the second project plan where you can add formulas and then manually update this sheet based on the information you have entered.

Hope this helps

All comments

MarceHolzhauzen

Berto_DA

Yes, the copying to rows would work. I tried it and it worked. Never did that before. Thank you for the help!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.