Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016.
Thanks
Christi
Hi Christi,
There isn't a way to clone a column so that it would copy all of the column data over to a new column in the same sheet.
You could create a new column and add a formula such as =[referenced column]@row with the "referenced column" being the column you would like to clone.
You could also duplicate a conditional formatting rule and change the column name. Details on conditional formatting rules can be found in our Help Center: http://help.smartsheet.com/articles/516359-conditional-formatting
When you have a moment, please submit a product enhancement request to let our Product team know that you'd like the ability to clone columns. The product enhancement request form is located in the Quick Links section to the right of this discussion.
Cheers!
Corinne
Still not native, but the SSFeatures browser extension adds this.
Keeps all the column settings, such as type, drop downs, formatting, formulas, etc.
You can read more about this feature here: https://ssfeatures.com/features/column-copy-paste
Best!
Disclosure: I'm the creator of SSFeatures.
Hi, We are a developer and building a custom web platform for one of our client who is using smartsheet. Our platform needs to get data from smartsheet and need to show the data in our custom UI. Could anyone recommend the APIs we should be using for this?
This solution updates a column formula across multiple sheets in a workspace. The script finds all sheets with a certain string in the name, finds a certain column by name on those sheets, and then updates all column formulas to a new column formula. At the time of posting, Control Center Global Updates did not allow me to…
We have a webhook created in one of our Smartsheets, and we've been noticing lately that the webhook callbacks immediately disables the webhook after 1 try, causing data discrepancies between the Smartsheet and the system it sends the data to. Here's an excerpt JSON message received from Smartsheet showing the callback…
