If / ifempty function help


This is adress cell. (consists of address1, adress2 and company)
I want it to look like

  1. If the company is empty, then A1, A2
  2. If the company is added, then A1, A2 / Company

So no matter what I try, there is still the ‘’/‘’ sign.
Can anyone help me sort this out?

Since / is inside the empty function, the if case will always be true thus, you will always get the / in result

What you can do is change the ifempty function to if and then add the logic to include / or not there. Something like this,

{{1.addressLine1}},{{1.addressLine2}} {{if(1.company != null & 1.company != emptystring; "" + 1.company)}}

1 Like