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

Speed

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.

Paul Newcome

Is there a reason you are adding new columns for each month as opposed to new rows for each month (reversed structure)?

Speed

Hi Paul,

To be honest, I haven't thought about flipping this to rows.

Paul Newcome

Typically that is a much easier structure to manage and report on.

Hollie Green

Can you add a row with just a Row ID through Automation? If you can how do you do it.

Paul Newcome

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.

Hollie Green

Thank you!

Speed

Thanks Paul. I will try the row option and reach out if I need help.

Paul Newcome

Happy to help. 👍️