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
Clay Team
APP
·
·
Hi Guy, which columns are?
Guy M.
·
·
I sent a screenshot of the relevant coloumns
Clay Team
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 Team
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 Team
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 Team
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 Team
APP
·
·
I'm not sure Guy
Guy M.
·
·
ok, thank you