Unable to get the formula correct to merge my data from multiple columns into one column.
Answers
-
I hope you're well and safe!
How do you want it to merge?
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.
-
I would like it to merge to look like this. I hope this is what you mean.
Monday: 2pm, 3pm, 4pm, 5pm, 6pm, 7pm, 8pm,
Tuesday: 9am, 10am, 11am, 12pm, 1pm, 2pm
Wednesday: 2pm, 3pm, 5pm, 6pm, 7pm, 8pm
Thursday: 9am, 10am, 11am, 12pm, 1pm, 2pm,
Friday: 9am, 10am, 11am, 12pm, 2pm,
I would then copy this availability and put it in the body of am email.
-
Try this:
=IF(Sunday@row <> "None of the above", "Sunday: " + SUBSTITUTE(Sunday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Monday@row <> "None of the above", "Monday: " + SUBSTITUTE(Monday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Tuesday@row <> "None of the above", "Tuesday: " + SUBSTITUTE(Tuesday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Wednesday@row <> "None of the above", "Wednesday: " + SUBSTITUTE(Wednesday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Thursday@row <> "None of the above", "Thursday: " + SUBSTITUTE(Thursday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Friday@row <> "None of the above", "Friday: " + SUBSTITUTE(Friday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Saturday@row <> "None of the above", "Saturday: " + SUBSTITUTE(Saturday@row, CHAR(10), ", ") + CHAR(10), "")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you! I will try this. Much appreciated.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!