Looking for a formula which will look at a series of cells but only return the information in one.
I have a series of columns based on job functions. Only one of the cells will have information and the rest will be blank. I am looking for a formula that will look at these cells and only return the information in the cell that has information in it. This will be combined with the information in two other cells to form a "Request Name" in the Primary column. The High Level Management column is a drop down and depending on the function one of the following columns will be populated.
what i have currently is =Subject@row + " + " + [High Level Function]@row+" + " but I can't get a handle on how to make it search the rest. Referencing the example below I would like the result to read:
American Chevrolet + Dealer Record Management + Dealer Reactivation
Help Article Resources
Check out the Formula Handbook template!