Copy and move selective columns
Waleed
✭✭✭
很多时候我们雪宝儿复制/移动选择性科勒姆ns ( within the row) either direct or automated , biut unforunately the platform force me to share the whole row with all columns including those columns with info that i do not wish to share .
Please consider the feeature to direct or autmated copy/move selective columns not all row
Thank you
Comments
-
Andrée Starå ✭✭✭✭✭✭Hi@Waleed
I hope you're well and safe!
好主意!这将是一个伟大的除了Smartsheet features.
Here's a possible workaround or workarounds
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.
Another option would be to use so-called helper sheets.In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet, and then copy/move the row from that sheet to the main destination sheet.
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
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 bymarking 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Samuel Mueller OverachieversThis would be a valuable feature. I have sent numerous enhancement requests for this idea. And Andree that's a great workaround I do this often, but it doesn't give you the option to move a row and send the comments, attachments etc, (so still manual). It would also be nice to be able to move attachments when a row is copied too.
-
Waleed ✭✭✭
I did not understand the workaround mentioned
As for helper sheet its the same issue as smart sheet will copy all colums in source sheet to helper sheet
Unless you meant to copy/paste data manually which usless as in this case to same time and to copy / paste it directly to destination sheet
Plus, its complecated process i need to send desired columns to destination sheet on specific action like assigned to a person/user
-
Tracey Tume ✭✭✭✭✭Hi
It would be great to copy rows/lines from sheet to sheet but with selected columns only.
I set up an automated copy and it doesn't work due to an automated number column in the souce sheet. SO frustrating as that column isn't need in the destination sheet so if I could deselect the unnecessary columns it would work.
Thanks
Tracey T
-
Andrée Starå ✭✭✭✭✭✭
Yes, it's a little complicated, but it works.
In short, this is how it works.
- Add a so-called helper sheet to which you copy the rows.
- Add another helper sheet where you'd use cross-sheet formulas (VLOOKUP or INDEX/MATCH) to collect only the necessary columns.
- Copy the rows from that sheet to the Destination sheet.
Make sense?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
tchoy ✭
I would like an enhancement to automation that we can select certain columns to copy to another sheet. We only want to see the selected columns in the destination sheet.
-
Rather than moving columns not necessary for another sheet, allow user to choose similar to how we select what someone sees in an update request or message.
-
I would also like to see better COPY and MOVE functionality with the ability to include Comments, Attachments, and History. Andree workaround would work (thank you!) but in a "planned" scenario, if you have quick one-off tasks, like this, it's too time-consuming. There is not any good way to bring along comments with a tedious string of copy-paste or using notepad and reformatting. It could be much simpler, perhaps through an automation process with a helper column.
The ability to "map" columns, and suppress the creation of columns not present at target would be great - perhaps with COPY if not MOVE (since with the latter, what happens to unmapped columns?)
-
Roger_B ✭✭✭✭When automating, there should be a way to copy specific cells (columns) into a new sheet. Currently I have a massive (or will be) sheet that works more like a database. When certain conditions are met, I can move or copy the whole row into a new sheet. Even better is that the new sheet will auto arrange the new data into columns with the same name. But I don't need all the data to go, just the data that matches.
Ex: Inventory tracking with columns like: name, last service, next service, cost, condition, ordered from, and more. I have a condition (and helper column) to automate "if last service is greater than next service" send a copy to "[email protected]". Service doesn't need the cost, or ordered from, but I can only send the whole row. The service sheet should be separate because it tracks what they do, and when completed sends me an email to update the date.
-
MichaelTCA ✭✭✭✭✭✭
Hello,
I think there should be a feature to transfer data from sheet to sheet by individual columns.
It can run exactly like data shuttle or an automation like generate documents, where each individual column is mapped.
Moving and copying rows are great, but I don't want to bring over all the unnecessary columns if I'm developing something new or reworking an old sheet.
-
Danielle Wilson Employee
You could potentially look intoDataMeshas a way to achieve this result as well! (There's a similar discussion here:https://community.smartsheet.com/discussion/92237/copy-specific-columns-from-one-sheet-to-another-linked/)
Danielle W.
Product Marketing
Smartsheet
-
@Andrée Starå, I've been trying to figure out your solution for an hour and am defeated. I get it in principle, but this part is losing me:
Doesn't that mean that, in that second Helper Sheet, I have to manually put a key field that VLOOKUP or INDEX/MATCH can use as a reference? I don't see any advantage to doing it that way, VS manually plugging that reference into the Destination Sheet (to use INDEX/MATCH) and skipping the two Helper Sheets in between.
I'm sure I must be missing something, but danged if I can figure out what.
-
MMcLain ✭✭✭
我爱如何允许您选择内容报告and choose what you need, can the same be made available when we copy a row from one Sheet to another?
Recently I have taken over the ownership of a lot of Sheets originally created and owned by another department for better interdepartmental visibility and data accessibility. However when the source and destination Sheets both have more than 50 columns, the destination Sheet ends with 100+ columns. Thank you!
-
Hello!
Now that we are implementing our workflow in Smartsheet; it would be a great improvement if we can transfer information from specific cells from one grid to another.
In our case, we have one sheet to make the request from my users to buy materials and then, when the purchase is completed, we would like to transfer specific data (like quantity, description and type of material) to another sheet where all the inventory available in our stock is...
I hope this example helped you to understand better how this idea could improve the communication between sheets.
Any comment, please let me know. We will be happy to help!
Best Regards,
Federico Prado
-
rlacout ✭✭
There is no clean way to populate a target sheet using automation/workflow upon a certain condition. I think the ability to use automation to copy only certain fields from a row to another sheet upon a condition would be a great addition. Currently, you can copy a row, but I think being to copy desired fields would be very helpful.
Here is one question I found on the community board, but the solution is not clean.
Please feel free to contact me at[email protected].
Thank you,
Rick
