Dates not copying over correctly when copying to another sheet

Crystal Panning

Hello,

Hoping someone can help me figure this out. I have a calendar template that I am copying over to a project plan via the Copy to another sheet function. When reviewing the template, the start dates are on a Sunday. When I copy over to the other sheet, the set date changes and the start dates move to a Thursday. I checked all settings (all settings & columns/types are the same for both) and tried removing the dates as well as the predecessors but can't figure out why the Set Date changes. Here are some screen shots to reference. One note to make is that when I copied over another calendar template that did not include dates yet or predecessors, this copied over fine and my start dates landed on a Sunday (same formula was used for both). Would having the dates and predecessors in the one template cause it to copy over incorrectly?

Calendar template.png

project plan copying to.png

Project settings.png

Genevieve P.

Hi @Crystal Panning

I see in the sheet you're copying over to that there's a formula in the "Baseline Start" and "End" date columns. Can you right click on the cell and select 'Edit Column Formula' and take a screen capture so we can see what that formula might be? It could be the formula that's adjust your dates.

Thanks!

Genevieve

Crystal Panning

I think I may have figured it out actually. I removed the date columns from the sheet I was copying from and they populated correctly in the sheet I copied to, so think we are good! Thank you!

Genevieve P.

Glad to hear it's resolved! Thanks for following up 😊