Unable to get the formula correct to merge my data from multiple columns into one column.

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @NortheasternPS

    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.

  • NortheasternPS
    edited 04/24/24

    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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Thank you! I will try this. Much appreciated.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!