Joining multiple select columns into one column
I have 2 columns that are multi-select and one column that a text column. I am looking for a formula to be able to get them all in one multi-select column.
I want multi-select column Missing 1 and multi-select column Missing 2 and text column ID problems to all combine in the multi-select column Missing.
I used the formula =[Missing 1]@row + char(10) + [Missing 2]@row + char(10) + [ID Problem]@row
But it seems that anytime one of the columns is blank I get #INVALID OPERATION error message.
I feel like there is an easy fix that I just can't seem to figure out. All help is appreciated.
Help Article Resources
Check out the Formula Handbook template!