This is adress cell. (consists of address1, adress2 and company)
I want it to look like
- If the company is empty, then A1, A2
- 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)}}
3 Likes
