How to Copy an Entire Column of Formula-Based Dates Without Selecting Individual Cells?

System

This discussion was created from comments split from: Copy all Data from one Column in a sheet to another column.

Paul Newcome

@brhea110891 You can set it as a column formula to get it to apply to the entire column and then convert it to a cell formula. The project settings don't mind cell formulas. It is column formulas they don't like.

brhea110891

I update a VERY large project timeline year to year by adding 2 new date columns (new year Start and new year Finish). I use a formula to add 365 days to the previous year dates. Then the new tasks dates get reviewed. This works fine. The issue is that I can't update Project Settings to the new year dates since the cells have a formula. My approach is to copy the contents of the columns with a formula to a new date column and then delete the ones with the formula, but I am experiencing trouble copying the entire column. How can I do this with out selecting individual cells?

Note: I make the updates to the same sheet because of all the workflows and Dynamic Views connected to the sheet.

Thank you.

Paul Newcome

@brhea110891 You can set it as a column formula to get it to apply to the entire column and then convert it to a cell formula. The project settings don't mind cell formulas. It is column formulas they don't like.

brhea110891

Love it! Thank you!

Paul Newcome

Happy to help. 👍️