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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Love it! Thank you!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives