The formula below is returning an error when there is no Landing Page URL provided. I want it to just return nothing (““). I am puling my hair out. Can someone tell me what I am doing wrong?
IF(
{Landing Page URL} = “”,
“”,
IF(
FIND("#", {Landing Page URL}) > 0,
LEFT({Landing Page URL}, FIND("#", {Landing Page URL}) - 1),
{Landing Page URL}
)
)