Merging Single & Multi Select Columns with Free Text into one Merged Column
I am in the midst of creating a giant SmartSheet for exporting to CSV for a client of mine. I am inputting keywords and metadata in single & multi-select columns, along with any miscellaneous keywords that I can create in another column.
I would like to merge all of these columns together into one separate column that has comma delimiters in them. I am new to creating functions, but I thought that a JOIN or = with a SUBSTITUTE thrown in there for adding commas would work, but so far I keep getting INVALID OPERATION whenever I try to merge them all together.
I could really use some help here, so any and all help is appreciated.
Help Article Resources
Check out the Formula Handbook template!