Workflow - Copy Rows
Hi all,
I'm creating a workflow that copies rows to a different sheet, however anytime the row is updated at the source, it creates a new row in the other sheet it's copying to instead of updating it. Is there a way to fix this?
Best Answer
-
You'll need to use a cross-sheet formula and either a VLOOKUP or an INDEX/MATCH structure to keep the row updated.
Make sense?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
You'll need to use a cross-sheet formula and either a VLOOKUP or an INDEX/MATCH structure to keep the row updated.
Make sense?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you for sending over your suggestion. Not sure that would work for me, since it would start to get messy between ongoing new adds and maintaining the formulas. Based on suggestions on a different post, I decided to create a report instead which I think might solve the issue.
Appreciate your feedback on this though. :)
Have a great week!
-
I am having this same problem except the report solution will not work for me. I need the end result to be a sheet that can be published to a calendar. The automation is copying rows which contain the word "submittal" into another sheet where we are tracking submittal dates from multiple schedules. As most of you probably know, these dates can change quite often. Every time the date is updated in the source sheet, it copies over as a new row instead of just updating the information from the original copy creating numerous entries for the same item. This is causing multiple dates for the same item and confusion all around. Is there a way to do this without manually delete all the duplicates?
Melissa Boehl
Smartsheet Architect | TurningPoint Energy
-
I've added the same answer for you and others.
Yes. 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.
Make sense?
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 help the Community by marking it as the accepted answer/helpful. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!