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

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?



  • Austin Smith
    Austin Smith ✭✭✭✭✭


    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!