Copy rows to new sheet automation or better way to do this?
Hi,
I have one sheet which has a form connected to it. Once someone submits the form, I have a drop down which I switch to "confirmed" when I have uploaded the submitters info.
Once I select, "Confirm" I want two specific cells in the row to copy to a different sheet. What would be the best way to do this? I have tried the copy row function, but cant seem to find a way to copy specific cells from the row to another sheet.
Thanks!
Answers
-
Unfortunately, it's not possible at the moment to select which columns that should be included, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could either hide the columns that you don't need in the other sheet or use a cross-sheet formula structure instead to show the information in the other sheet when you switch to confirmed.
Make sense?
Would any of those options work?
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.
-
Hi Andree,
Hiding the columns may work - however is it possible to place a Created (Date) field with the date of when the row was copied over to the other sheet? I was already using the Created (Date) field in the first sheet and the option seems to be greyed out for me on the destination sheet where the rows are copied to.
Thanks!
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives