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), "")
-
Thank you! I will try this. Much appreciated.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!