Column header presets


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?


  • Amanda Alv
    Amanda Alv ✭✭✭✭✭


    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!