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, pleaseVisit the Current Forums.
Copy/clone a column WITHIN a sheet
Hi,
I see lots of information sating you can't copy a column from one sheet to another. I want to make duplicates of a column WITHIN the same sheet. Is this possible?
The reason is that I have a long dropdown list and some cell (not row) conditional formatting in a column which will be the same for all 7 columns and this would save me having to create 7 times.
I may be approaching the whole thing poorly so all advice is welcome
Thanks
Rob
Comments
-
J. Craig Williams ✭✭✭✭✭✭I would love this feature too.
Even duplicating the drop box list would be a time saver.
Craig
-
Dave D ✭
Just add a new column and copy and paste the cell data and predetermined column values to the new row. You can also duplicate conditional formatting rules, just change the column they are looking to.
-
Brad Jones ✭✭✭✭✭✭+1 vote to copying a column - and being able to use the format painter from column to column.
-
Kennedy Stomps EmployeeHi Brad-- I've added your votes for these features!
-
Daniel Wiant ✭✭✭
me too!
-
CarlFox ✭
Hey,
I was looking to do a similar task, and I ended up creating a new column and entering
=([Original_Column]1)
into the first cell, extend the formula all the way down the sheet and you should end up with a duplicated column, which will also automatically update as you add new rows.
Hope this helps,
Carl
-
J. Craig Williams ✭✭✭✭✭✭
Carl,
I believe you have missed the point of the request.
An example of what we are looking for:
I have a column named "Date 1" and it is Date type column.I make it blue background.
I want to create 6 more columns that are Date columns with a blue background, in effect "cloning" the column.
I do this now with the API - from a command line I enter sheet ID, column ID, and how many instances I want. It would be nice if the tool would do this for us.
Craig
-
I have had a request from a team member, would also like to duplicate - the Comments column - so that different members of the process only need to see comments about their process.
Marie
-
Tracey Siepser ✭✭✭✭Please add my vote for this duplicating/cloning column feature too!
-
zoltan ✭
A want the feature too
-
RebSchr ✭✭✭✭✭Vote "Yes" for this feature -I ran into this issue today creating a training matrix. All of my columns use the same drop down list. There was not easy way to copy the column properties and I had to repeat this task 50+ times.
-
please add my vote as well, i am trying add data for a menu and i need QTY columns for every item. Had to do this one by one recreating each column.
-
Bill Stadler ✭✭Mine too!
-
BigAl ✭✭✭✭
+1 for this feature from my side. It is awful to create the same columns again and again ONLY because there is no copy function.
-
EHatch ✭✭✭
另一个请求!我最终使用戴夫D 's suggestion above which made it a bit easier but still tedious with so many columns...
Categories
If you're either the Owner or the Admin of a Dashboard on a Business or Enterprise plan, you can see Views by going to the Activity Log<\/strong> of the Dashboard (File > Activity Log).<\/p> Here you can add a Date Range and filter by the Views action:<\/p> Can you clarify if this resolves your current request or if you had more specifics to your Idea?<\/p> Thanks!<\/p> Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":112240,"type":"question","name":"COUNTIFS and SUMIFS functions?","excerpt":"I created a sheet that is a roll up of various information derived from a master sheet. I am using this to create a dashboard. However, I am stuck on a few formulas. I tried SUMIFS and COUNTIFS, but I cant get it right and either get invalid ref or unparseable. I would like to be able to count the number of stars appear…","snippet":"I created a sheet that is a roll up of various information derived from a master sheet. I am using this to create a dashboard. However, I am stuck on a few formulas. I tried…","categoryID":322,"dateInserted":"2023-10-26T21:52:04+00:00","dateUpdated":null,"dateLastComment":"2023-10-27T11:40:09+00:00","insertUserID":169153,"insertUser":{"userID":169153,"name":"SadieW","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/SadieW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T12:01:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":169153,"lastUser":{"userID":169153,"name":"SadieW","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/SadieW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T12:01:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3396765133,"url":"https:\/\/community.smartsheet.com\/discussion\/112240\/countifs-and-sumifs-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112240\/countifs-and-sumifs-functions","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":112240,"commentID":401986,"name":"Re: COUNTIFS and SUMIFS functions?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401986#Comment_401986","dateInserted":"2023-10-27T11:40:09+00:00","insertUserID":169153,"insertUser":{"userID":169153,"name":"SadieW","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/SadieW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T12:01:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/GS7AEDE2AJOX\/ssque-jpg.jpg","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/GS7AEDE2AJOX\/ssque-jpg.jpg","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/GS7AEDE2AJOX\/ssque-jpg.jpg","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/GS7AEDE2AJOX\/ssque-jpg.jpg","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/GS7AEDE2AJOX\/ssque-jpg.jpg","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/GS7AEDE2AJOX\/ssque-jpg.jpg"},"alt":"SSQue.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-27T11:52:29+00:00","dateAnswered":"2023-10-27T03:53:03+00:00","acceptedAnswers":[{"commentID":401962,"body":"![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/083246FKS6MW\/screenshot-2023-10-27-at-14-37-14.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
