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
Check out the Formula Handbook template!