Dates not copying over correctly when copying to another sheet

Crystal Panning
Crystal Panning ✭✭✭✭
edited 06/16/22 in Formulas and Functions


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!