Combining columns

Options

Hi!

I'm trying to use the combined formula, but every time the 1st and 2nd columns are empty, the 3rd column brings the value with a 0 at the beginning.

Thank you in advance for your help.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Hi @androdriguez65476 ,

    Try:

    =Join(Collect([1st column]:[last column], ISTEXT(@Cell)),"-")

    Where [1st colum ] is the name of the left most column and [last column] is the right most.

    It should return the contents of each cell with text separated by a "-".

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!