Duplicate Row
UPDATE: I figured it out :)
Hello!
I am trying to get a row to duplicate if one column meets certain criteria. So if the cuff size is listed as large we need to duplicate the row to let the vendor know there is an additional item to be ordered, which has a separate SKU and price, how would I go about doing this? If Cuff size is large, they would have a row for standard, as well as a row for large...see screenshot for reference, there should be two rows with the information from row 4, one row would be standard cuff an one row for large cuff...
The customer fills out the form and selects either standard or large, if they select large we need it to duplicate the row and have the size also be listed as standard as it is two separate items to be ordered. Customers who submit the form automatically receive the standard size cuff and the large cuff is separately ordered.
Answers
-
Hi @CaraBart28
I hope you're well and safe!
Excellent! Glad you got it working.
Feel free to share your solution.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking your post with 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.
-
Hi @Andrée Starå ,
So Basically what I did was created an automation to copy the row over to a separate sheet, that separate sheet then duplicates the row, and there is an automation set to change the contents of the cell. Once the contents of the cell are changed the row copies over to the original sheet, thus creating a duplicate row with the updated cell information.
Hope this makes sense!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!