Join columns, not side by side, and skip columns with no info


I am looking to join multiple columns using a "-" as deliminator and I dont have the columns side by side to select range and use Join function.

I also want it to skip columns that are blank.

Also - I notice in Smartsheet i have to use date format 10/15/2020 is there a way to change it to 10-15-20 (I use "-" as separator and want to keep consistency in date)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!