Merging Columns with Formula, Even When Empty - How to

how can I merge coloumns that one of them is a formula, and it can sometimes be empty? The merge always uses it even if it's empty

Guy M.
·
·
https://app.clay.com/workspaces/210823/tables/t_VojjWTV7tIAw/views/gv_5gc25Rn7V4Hq
Guy M.
·
·
Clay T.
APP
·
·
Hi Guy, which columns are?
Guy M.
·
·
I sent a screenshot of the relevant coloumns
Clay T.
APP
·
·
Sorry but I'm not following you, I see that you already did it, do you want to use another input if its empty?
Guy M.
·
·
I want to merge the two left coloums from the screenshot, into the right one. However, it always gets the most left coloumn, because it doesn't identify it as an empty coloumn. Do you see that?
Clay T.
APP
·
·
like this?
eb2e9019-e323-4ed2-bb08-7fe525668e52.png(39 kB)
Guy M.
·
·
Yes
Guy M.
·
·
why did it not work the way I did it though?
Clay T.
APP
·
·
you need to use the result of the AI not the AI column
Guy M.
·
·
But what's wrong with the second formula? It does take the result from that coloumn
Clay T.
APP
·
·
I would use the merge formulas alone and then add the linkedin url in another column
Guy M.
·
·
I don't understand
Guy M.
·
·
what do you mean by "alone"?
Guy M.
·
·
oh I understand. It does work expected when I remove the "linkined" text. But why is that?
Clay T.
APP
·
·
I'm not sure Guy
Guy M.
·
·
ok, thank you