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?
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!