Auto populate column titles?

Lindsay F

Hi all,

I've recently taken over a sheet from a co-worker who left the company. This sheet is used to track which employee is out of office on weekdays and which employees are covering their particular work duties. The previous manager had populated the column out to 1/14/20. Now that we are approaching this date, I need to extend the calendar out and am wondering if there is any way to do so without having to manually rename each column to a date (i.e., 1/15, 1/16, and so on). Here is an image that will hopefully give you an idea if what I am trying to do. If this isn't feasible, I'm open to any ideas you have for making this more efficient. Thanks!

Andrée Starå

Hi Lindsey,

Unfortunately, you have to change the names manually.

A possible workaround/alternative could be to create everything in an excel sheet and then import it to Smartsheet and select the row with the dates to be the column names and then copy that row to the main sheet. That would create the columns that are missing.

Make sense? Would that help?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD​​​​​​​

Andrée Starå

Hi Lindsey,

Unfortunately, you have to change the names manually.

A possible workaround/alternative could be to create everything in an excel sheet and then import it to Smartsheet and select the row with the dates to be the column names and then copy that row to the main sheet. That would create the columns that are missing.

Make sense? Would that help?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD​​​​​​​

Lindsay F

Thanks, Andrée! I did as you suggested and it worked perfectly.

Andrée Starå

Excellent!

Happy to help!