Start and end date columns advanced by one year

Rachel Jacob

Hi all,

I'm trying to flip ALL dates in the start column ahead by 1 year and ALL dates in the finish column ahead by one year. We're utilizing Smartsheet as our critical path platform so this is something we need to do year over year and manually updating ~1000 rows is not realistic.

An exact date is not the most important thing, within a day or two of these dates flipped ahead one year is totally fine!

I've perused through other discussion questions and threads and can't find a solution so far, thanks in advance for your support!

Paul Newcome

You need to make sure you have the column names that are in your sheet. Try Start instead of [Start Date].

Paul Newcome

You could insert a temporary date column and use

=DATE(YEAR([Start Date]@row) + 1, MONTH([Start Date]@row), DAY([Start Date]@row))

Dragfill this for all rows.

Copy, then "Paste Special" and select "Values" to paste the temporary column dates into the Start Date column. Repeat for [End Date] and then you can delete the temporary column.

Rachel Jacob

Thanks Paul.

I think I've done step 1 here by including the formula on a row but it says #unparseable, so presumably i'm not including this properly! Help? I'm an A1 beginner with formulas, obviously :)

Paul Newcome

You need to make sure you have the column names that are in your sheet. Try Start instead of [Start Date].

Rachel Jacob

Thank you so much, this was so helpful!!!

Paul Newcome

Happy to help. 👍️