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

System
System Employee
edited 09/13/24 in Smartsheet Basics
This discussion was created from comments split from: Copy all Data from one Column in a sheet to another column.

Best Answer

Answers

  • brhea110891
    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
    Paul Newcome ✭✭✭✭✭✭
    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • brhea110891
    brhea110891 ✭✭✭✭

    Love it! Thank you!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com