Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Copy Column Properties

Options
Lisa Dion
Lisa Dion
edited 12/09/19 in Archived 2016 Posts

Hi,

 

I am creating a new sheet that needs to have 20+columns that are all a dropdown column type, with the same dropdown responses.  Is there a copy function for setting up the columns?

 

Thanks,

Lisa

Comments

  • Kennedy Stomps
    Options

    Hi Lisa-- We don't currently offer the ability to copy columns within a sheet but I've added your vote for this to our enhancement request list. In the meantime, you would probably want to copy the dropdown list items and paste them into the column settings panel.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Add my vote too, please.

     

    Craig

  • Kennedy Stomps
    Kennedy Stomps Employee
    edited 08/09/16
    Options

    I have added your vote, Craig!

  • Randy B
    Options

    I vote this up too!

     

  • MK
    MK
    Options

    Please add my vote for this as well.

  • Paul Johnson1
    Paul Johnson1 ✭✭✭✭
    Options

    Please add my vote for copy column feature. I have 40 project sheets to update with six extra columns and would prefer to copy one set and paste rather than do 240 separate copies!!! This is an incredible waste of time. Copy and paste is such a fundamental feature requirement in all software. Please help as soon as possible !!!!

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 01/22/18
    Options

    Paul,

    It might be too late for this, but here's a trick:

    1. Create a sheet with the 6 columns to be added.

    2. Add text to one of the columns "new row here" or something to remind you to delete it later.

    Something unique is also useful like "sdfsd1!" (see below)

    3. Select that row and use Copy To Another Sheet.

    4. Select a project destination sheet.

    (Here's the tedious part -- repeat 3 & 4 for the other 39 sheets)

    The columns (with Type) will be copied to each sheet.

    5. You can check using Search (sdfsd1! will be found on the sheets that have the new columns)

    Slightly less painful than creating  6x40 columns one at a time.

    Update:

    If this happens more than once to the same 40 sheets, I would suggest looking at Zapier to do steps 3 & 4. It could be done with a single Zap. It would be easy to set up, if you know what you are doing, but not so easy if you don't. I don't mean the flippantly, I just mean I don't have time to fully document the process here but I have done it before and could do it again.

    Craig

  • pkampf
    Options

    This would be great, any word on progress for this feature?

  • ker9
    ker9 ✭✭✭✭✭✭
    Options

    Two and half years later and we still can't copy columns.  Seems so basic.

  • Please add my vote too, this would be hugely helpful.  Any progress on adding the feature?

  • Shaine Greenwood
    Options

    Hi all—

    To make sure that your feedback reaches our Product team, please submit your vote through the Enhancement Request form underneath Quick links to the right of the community site.

    Thanks!

This discussion has been closed.