Add new column to multiple sheets

System

This discussion was created from comments split from: Adding a new Column to multiple workbooks.

Sedláček

Hi,

I have the same problem, but I have more than 200 sheets. Has anyone found a new and more efficient solution in the meantime?

Thank you.

Naeem Ejaz

If your organization uses Smartsheet Control Center:

• You can add a global update that pushes structural changes (like adding columns) to all projects/sheets created through Control Center.

Steps:

1. Go to Control Center > Manage Programs.
2. Select Global Updates > Add Column.
3. Choose the column name and type.
4. Apply the update to the target sheets.

Marcela

Hello @Sedláček , tagging you here so you don't miss the response above!

Sedláček

Thank you both, but i'm affraid my subscription dodoesn't contain this feature :(

Andrée Starå

https://community.smartsheet.com/discussion/140092/add-new-column-to-multiple-sheets

Hi,

I hope you're well and safe!

What is it exactly that you'd like to do?

❓ Adding one or multiple columns, and should they have any formulas included?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Sedláček

Der Andrée,

thank you very much for reply and i hope you are fine too.

Yes, I was trying to add a column to already created projects (and there are quite a few of them already and adding a new column one project at a time would take weeks). If there was an option to add a column to selected (all) projects, that would be great and if it could even be done with formulas, that would be the absolute best.

Have a nice weekend 👍

Andrée Starå

https://community.smartsheet.com/discussion/comment/487592#Comment_487592

Happy to help!

Unfortunately, it's probably the simplest to do it manually if it's only one column.

As a potential workaround, depending on the use case, you could add it as a Sheet Summary Cell instead, and then you can push it to multiple sheets at the same time.

Would that work/help?

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Sedláček

Dear Andrée,

thank you for your care, i'm affraid it will be the only way how to add that column.

But for sure, i'm affraid i don't fully understand the solution with Sheet Summary Cell instead. Could you desdescribe that little bit closer, if it is not too complicated, please?

Thank you very much.