Pasting a CONCATENATE formula from excel with line delimiters
Morning
We process some job forms in excel where a transfer line combines the information so we can then paste the information into our Smartsheet for the work to be done and tracked.
All the information pastes in nicely except the cell with the CONCATENATE formula with the line delimiters in it. It pastes the combined 10 lines of information into 10 rows in smartsheet instead of joining them all in the one cell on the same line as the rest of the text.
We used to be able to do this but is hasn't worked for a couple of years and am upgrading some things and want to get it fixed.
I have tried CONCATENATE, and TEXTJOIN and joining the text by & in excel to see if the different formulas might be the issue. No luck.
Any help would be gratefully received.
Tracey T
Answers
-
Hi @Tracey Tume
I hope you're well and safe!
Try to double-click the cell before you paste.
Did 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, 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: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.
-
Morning
Thank you for your answer. The issue is we paste approximately 50 columns into the row at once.
We used to be able to paste it and have the multi-lined cell paste into one cell but it doesn't any longer. We now paste 49 of the columns and past the multi-lined cell separately. I thought it might have had something to do with the excel formula/set up in the cell but perhaps its a Smartsheet issue.
Thanks for trying.
Kind regards
Tracey T
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!