Multiple columns

subhashgt

Hi

How do i add multiple columns at one time, as an example how do I add 50 columns at a time.

Andrée Starå

Hi @subhashgt

I hope you're well and safe!

Unfortunately, it's not possible to add more than 5 now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• You can have a so-called helper sheet and copy a row to other sheets, and then all columns from the sheet will be added.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @subhashgt

I hope you're well and safe!

Unfortunately, it's not possible to add more than 5 now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• You can have a so-called helper sheet and copy a row to other sheets, and then all columns from the sheet will be added.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

subhashgt

@Andrée Starå

Thank you for the quick response

Genevieve P.

Hi @subhashgt

If you have a sheet in your Smartsheet instance that you want to mimic column-wise, you could Copy a Row from that sheet to another one. This will automatically add all the same columns to your destination sheet if they don't exist already! Here's more information: Copy rows to another sheet

subhashgt

Hi @Genevieve P.

Thanks for answering

I want to automatically migrate the changes doing to the master sheet to the slave sheets, is that possible?

Andrée Starå

@subhashgt

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@subhashgt

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row id on as many rows as you think you need in the Destination sheet.

Would that work?