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.
-
