I hope you're well and safe!
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 week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅了我的帖子(s)帮助或回答你的问题吗tion 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.
@Molly YangIf you don't to Sam's point above need attachments on the row and have a unique identifier per row (like an audit number) you might considerDataMesh!
Danielle W.
Product Marketing
Smartsheet
@Danielle WilsonIf you got time, I would like to share my work, I don't believe the mentioned functions could solve the problem. Thank you so much.
@Andrée Staråthanks, unfortunately, this is not going to solve the issues, my workflow is different. thanks
Ok. Happy to help!
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.
@Molly YangI'd recommend reaching out to your account team to discuss options or booking aPro Deskto discuss options & DataMesh, if you have Pro Desk on your account!
Danielle W.
Product Marketing
Smartsheet
This would be very helpful! I am currently working on converting a huge file over from Excel to Smartsheet. Due to Smartsheet sheet size constraints I have to be creative with multiple sheets now. Allowing columns to copy over to another sheet without having to copy the entire row would help so much!
I am requesting the ability to create an automation where you can copy a single cell to a new sheet. Currently there is an automation to copy an entire row to another sheet however this is not helpful if the sheet structure is not the same.
Can it be made possible to move certain columns of a row instead of the whole row, i.e., if I had 10 rows with data columns A, B, C, D and I wanted to move just column A & D from all rows to another sheet.
Hope this makes sense?
Danielle W.
Product Marketing
Smartsheet
@Danielle WilsonThank you, I do not have the necessary access, but it is good to know there is this tool. I will keep this in mind and see if I can get this made available to me within my business.
Hi@VLD
I hope you're well and safe!
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 week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅了我的帖子(s)帮助或回答你的问题吗tion 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.
@Andrée Staråthanks, I have only just found INDEX and am using that. It was INDEX that made me think there must be another way and now I know there is. Thank you again and I will try your suggestion.
Excellent!
Happy to help!
✅Remember!了我的帖子(s)帮助或回答你的问题吗tion 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.
目前我使用自动化来复制或移动rows when the trigger is met, however in a lot of cases, not all of the columns are needed. It would be helpful in the automation, you can choose which columns you want to move or copy instead of having to copy / move the entire row of information.