Column header presets

Options

Can I use a filter or a rule to automatically set up my columns in Smart Sheet instead of typing Column headers

I want Jan 2022 estimate, Jan 2022 actuals, Jan 2022 variance then in the next three columns I want to add Feb 2022 estimate, Feb 2022 actuals Feb 2022 variance all the way to 2025? I cant copy and paste the column headers and then just change the date.

Any idea how to do this in your column header row without typing this out to 2025?

Answers

  • Amanda Alv
    Amanda Alv ✭✭✭✭✭
    Options

    Hi,

    To my knowledge, this cannot be done (definitely would love to hear if that is not the case!). However, if this is a new sheet and not one already in progress, you could leverage Excel. Create an excel sheet with the first 6 or so columns and then autofill from there. That should get you the structure you're looking for quickly, which can then be imported into a new Smartsheet, giving you all the columns you want.

    Let me know if that helps or if you find a more direct way!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!