How to quickly add each week to cells in the same row.

ShaneL.

Hi there. I am trying to create a report where the first row has the date of each week in the cells.

In Excel, you can type in dates in 2 cells (e.g., 4/2/23 & 4/9/23) and then drag them to the right to auto add the remaining dates.

Is there a way to do this in Smartsheet?

Thanks!

Austin Smith

@ShaneL.

Not that I've found. Fastest, easiest way to bulk insert or update is to do it in excel and copy/paste, especially if it's static data or something you can hide if not needed. If it's irregular, maybe pre-create columns and set up an automation to fill cells based on other cells.