# Concatenate Value not showing up

**URL:** <https://community.hubspot.com/t/concatenate-value-not-showing-up/108263>\
**Category:** CRM\
**Tags:** contacts\
**Created:** [May 30, 2024, 1:41am UTC](https://community.hubspot.com/t/concatenate-value-not-showing-up/108263 "2024-05-30T01:41:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![moree20](https://avatars.discourse-cdn.com/v4/letter/m/6de8d8/32.png) [@moree20](https://community.hubspot.com/u/moree20)\
**Post date:** [May 30, 2024, 1:41am UTC](https://community.hubspot.com/t/concatenate-value-not-showing-up/108263/1 "2024-05-30T01:41:28Z")

</div>

Hi

I have a property with a concatenate formula, the issue is that some contacts are not showing the value of the property itself while some contacts are just fine. Why do you think this happened?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [May 30, 2024, 4:17am UTC](https://community.hubspot.com/t/concatenate-value-not-showing-up/108263/2 "2024-05-30T04:17:03Z")

</div>

Hi @moree20,

Can you share a screenshot of the formula and a screenshot of the property values of a contact where it’s working and one where it’s not working?

Best regards

---

<div class="post-metadata">

**Author:** ![moree20](https://avatars.discourse-cdn.com/v4/letter/m/6de8d8/32.png) [@moree20](https://community.hubspot.com/u/moree20)\
**Post date:** [May 30, 2024, 6:18am UTC](https://community.hubspot.com/t/concatenate-value-not-showing-up/108263/3 "2024-05-30T06:18:49Z")

</div>

I have a theory on why it’s not showing, so my question now is does the concatenate formula only works if all the strings have value? If it reads that in a contact, the property added as a string is missing a value, then the formula wouldn’t work, is that right? Is it like one all or nothing.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [May 30, 2024, 6:22am UTC](https://community.hubspot.com/t/concatenate-value-not-showing-up/108263/4 "2024-05-30T06:22:50Z")

</div>

@moree20 that’s correct, see this test:

 ![karstenkoehler_0-1717050079715.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/2/9253d75e46f42827b1724320492e9f612f6d484a.png)

You could work around then with an IF statement that checks whether all building blocks are known - and then creating a fallback if they aren’t.

---

<div class="post-metadata">

**Author:** ![moree20](https://avatars.discourse-cdn.com/v4/letter/m/6de8d8/32.png) [@moree20](https://community.hubspot.com/u/moree20)\
**Post date:** [May 31, 2024, 1:04am UTC](https://community.hubspot.com/t/concatenate-value-not-showing-up/108263/5 "2024-05-31T01:04:29Z")

</div>

Can you suggest how to use the IF function for that scenario? so we can still get what we are trying to achieve?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [May 31, 2024, 3:30am UTC](https://community.hubspot.com/t/concatenate-value-not-showing-up/108263/6 "2024-05-31T03:30:32Z")

</div>

@moree20 could you please share your current formula?