Hard Code a Copied Cell
SHEET 1: has an auto-number field.
SHEET 2: I am copying (via automation) the data from SHEET 1 to SHEET 2. SHEET 2 already has an auto-number field.
When the rows are copied from SHEET 1 to SHEET 2 auto-number fields go into the existing auto-number field.
I believe this is because you can only have ONE auto-number field per sheet.
So my question is.... is there a way to HARD CODE the auto-number field in SHEET 1 (into its own seperate column that is not auto-number column) so I can, in turn, copy that HARD CODE number can be moved to SHEET 2?
Thanks!
😪
Best Answer
-
Hi @Teri Ann
I hope you're well and safe!
Here's a possible workaround or workarounds
- You could add a so-called helper column that references the auto-number column in the source sheet, and in that way, it will be stored in the 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
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up 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: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
-
Hi @Teri Ann
I hope you're well and safe!
Here's a possible workaround or workarounds
- You could add a so-called helper column that references the auto-number column in the source sheet, and in that way, it will be stored in the 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
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up 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: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.
-
Andree,
I believe that is the route that I am taking and that seems to work. I will get back to you on this issue if there are any issues by team members. 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
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives