How to Copy an Entire Column of Formula-Based Dates Without Selecting Individual Cells?
Best Answer
-
@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.
Answers
-
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.
-
@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.
-
Love it! Thank you!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives