Copy and Paste Column's

Bruce · 09/19/22

Need a way to copy and paste columns from one "standard columns" sheet to new sheets. This would be similar to a template but more flexible.

SRLinhardt · 08/04/22

I would like to be able to copy or insert a new column into multiple sheets. This would be a similar concept to copying the summary across multiple sheets.

Sara Campbell · 09/27/22

agree! I'd like to even be able to do it within a sheet - often my new column already has a like column in the same sheet.

Sameer K · 10/22/22

Ability to duplicate existing column aka copy and paste entire column to a new column.

There could be many use cases but jus one that is very common:

Users may have dashboards built for fiscal years. Now if there are multiple metrics widgets that display values from columns for current fiscal year quarters then for the next fiscal year instead going through the pain of recreating the metrics widgets for the new fiscal year quarters, it will be great if we can instead reuse existing columns by renaming them and moving the data for past fiscal year to new columns in the sheet. To move the data the copy/paste or duplicate column functionality will be very helpful.

gwson · 11/11/22

是的,特别是联系人列表列。我们有一个马ster directory column in a database that has all of our company's contacts. We need these same contacts to be on different forms across different sheets. We need a way to have these contacts copied and pasted over to those sheets.

PS. Please add a visibility checkbox to the contact list column so that it can display contact names or contact emails depending on preference.

THe issue is now that sometimes contact columns display names or emails, depending if names have been associated with them. We need them sometimes to be displayed as emails though so we can copy paste those emails. If they are with names, only names can copy and paste.

Olen Ronning · 12/06/22

We love the idea of being able to leverage column definitions more easily and widely within your Smartsheet solutions. The ability to duplicate a column and its properties within the same sheet is on our roadmap and the ability to copy a column definition across sheets is on our radar as something we are exploring for the future.

This also relates to an already submitted idea for dynamic dropdowns (used to centrally define column properties for reuse across multiple solutions). Please take a look up-vote and comment as you like:https://community.smartsheet.com/discussion/92421/dynamic-dropdowns

Julie Becker · 12/06/22

I 100% agree, now lets see if they actually listen to our ideas and implement them.

Vanessa Scott · 02/06/23

The ability to copy a column with properties.

Chris K · 02/06/23

Please add this functionality

Yvette Moreland · 03/09/23

The ability to copy a column that would carry over the column type, dropdown options and column description. Thus only requiring to give the column a unique name.

I use sheets with columns to indicate availability for particular days, with four dropdown options. Each time I add a new date, I have to insert a column, format as dropdown, add the dropdown options, and add the column description. Since all columns have the same dropdown options and same description, it would be very helpful to copy a column and give the new column a unique name.

Sign in to submit new ideas and vote

Copy and Paste Column's

On Wishlist·Last Updated12/06/22

Comments

Categories