Is there a way I can easily add more columns to the sheet

Hi,
I want to columns, one per month for the life of the project to help track finances. I am thinking something similar to Excel here. I am not sure if such a feature is available. I can create a template, but would need to change it for every project as required and want to make it easier for PMs if projects run for years. Any ideas or help would be greatly appreciated.
Answers
-
Is there a reason you are adding new columns for each month as opposed to new rows for each month (reversed structure)?
-
Hi Paul,
To be honest, I haven't thought about flipping this to rows.
-
Typically that is a much easier structure to manage and report on.
-
Can you add a row with just a Row ID through Automation? If you can how do you do it.
-
You would need a second sheet. Insert the same columns as the working sheet with the exception of the auto-number column. You are going to want some type of helper column that can be hidden but contains data in the top row. The you would set up a copy row automation to run on a recurring basis to copy this top row over to the main working sheet.
-
Thank you!
-
Thanks Paul. I will try the row option and reach out if I need help.
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 75 Community Job Board
- 502 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives