Mastering Address Cell Formatting on Make.com

Have you ever found yourself in a situation where you're trying to format an address cell that consists of address1, address2, and company, but you're having trouble with the formatting? Specifically, you want it to look like this:

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

But no matter what you try, there is still the ‘’/‘’ sign. Well, you're not alone. This is a common challenge that many users face. But don't worry, there's a solution.

The issue arises because the / is inside the empty function, which means the if case will always be true. As a result, you will always get the / in the result. So, how do you fix this?

What you can do is change the ifempty function to if and then add the logic to include / or not there. Here's an example of how you can do this:

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

By doing this, you can ensure that the / only appears when the company is added, and not when it's empty.

Remember, troubleshooting is a key part of any process. If you're still having trouble, try going through the steps again and make sure you're entering everything correctly. And don't forget, practice makes perfect!

In conclusion, formatting an address cell can be a bit tricky, but with the right approach, you can easily overcome this challenge. Just remember to change the ifempty function to if and add the logic to include / or not there. Happy formatting!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.