Does anyone know how to autofill dates across a sheet?

Naomi Moore

Looking for SS to auto populate months - e.g. start with Jan 20 and then Feb 20 and then is there a way to get the rest of the months to auto populate across (in Excel you would just highlight and drag and it would auto populate). Thanks

Naomi Moore

Thanks Andrea. So I guess that unfortunately the answer is no then. It doesn't! Not to worry, I'll use Excel instead.

Andrée Starå

Hi Naomi,

Do you want to add them the rows or the columns?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Naomi Moore

Hi - just columns

Jan 20 Feb 20 Mar 20 April 20 etc...

Andrée Starå

Ok.

The easiest method would be to set it up in an Excel sheet and then import it, and either use that sheet or copy a row to the sheet where you want them.

Make sense? Would that work?

Naomi Moore

Thanks Andrea. So I guess that unfortunately the answer is no then. It doesn't! Not to worry, I'll use Excel instead.

Andrée Starå

Happy to help!

Please submit an Enhancement Request when you have a moment

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!