# Custom Formula Fields

**URL:** <https://community.hubspot.com/t/custom-formula-fields/143857>\
**Category:** Reporting & Analytics\
**Tags:** reports\
**Created:** [December 9, 2025, 9:57pm UTC](https://community.hubspot.com/t/custom-formula-fields/143857 "2025-12-09T21:57:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JGrayson6](https://avatars.discourse-cdn.com/v4/letter/j/838e76/32.png) [@JGrayson6](https://community.hubspot.com/u/JGrayson6)\
**Post date:** [December 9, 2025, 9:57pm UTC](https://community.hubspot.com/t/custom-formula-fields/143857/1 "2025-12-09T21:57:37Z")

</div>

Hello! I need assistance creating a custom formula in HubSpot. I’m trying to count the number of conversions if a recent conversion (form name) includes any of the following:

Arts, Wit, Geo, Mag, ELA

I created this formula, but there are a few erros that I do not know how to resolve.

COUNT(IF(Contains([CONTACT.recent\_conversion\_event\_name], “Arts”, “Geo”, “Wit”, “Mag”, “ELA”, 1, NULL)))

Thanks so much for everyone’s help. I really need a class in creating these custom formulas and the AI tool is not that helpful yet.

Jenny

---

<div class="post-metadata">

**Author:** ![stassey](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stassey/32/36_2.png) [@stassey](https://community.hubspot.com/u/stassey)\
**Post date:** [December 9, 2025, 10:10pm UTC](https://community.hubspot.com/t/custom-formula-fields/143857/2 "2025-12-09T22:10:30Z")

</div>

Hi @JGrayson6,

Thanks for posting in the Community!

@karstenkoehler contributed to this post from last week, which I believe you may find helpful! [https://community.hubspot.com/t5/Dashboards-Reporting/Need-Formulas-to-Bucket-Property-Values/m-p/1230788#M13325](https://community.hubspot.com/t5/Dashboards-Reporting/Need-Formulas-to-Bucket-Property-Values/m-p/1230788#M13325)

I hope this helps guide you in the right direction. Please don’t hesitate to reach out if you have any additional questions, both myself and the Community are here to assist!  
Sam, Community Manager

---

<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:** [December 10, 2025, 4:53am UTC](https://community.hubspot.com/t/custom-formula-fields/143857/3 "2025-12-10T04:53:04Z")

</div>

Hi @JGrayson6,

A few things:

- You can omit the COUNT, the IF statement is enough.
- HubSpot expects statements in upper case, it should be CONTAINS

That should fix it 🙂

Best regards

---

<div class="post-metadata">

**Author:** ![JGrayson6](https://avatars.discourse-cdn.com/v4/letter/j/838e76/32.png) [@JGrayson6](https://community.hubspot.com/u/JGrayson6)\
**Post date:** [December 10, 2025, 2:55pm UTC](https://community.hubspot.com/t/custom-formula-fields/143857/4 "2025-12-10T14:55:08Z")

</div>

Thank you, this was the AI-generated solution that HubSpot came up with, and it worked. I finally asked the quesiton in the correct way. 😁

COUNT(IF(CONTAINS([CONTACT.recent\_conversion\_event\_name], “Arts”) OR CONTAINS([CONTACT.recent\_conversion\_event\_name], “Geo”) OR CONTAINS([CONTACT.recent\_conversion\_event\_name], “Wit”) OR CONTAINS([CONTACT.recent\_conversion\_event\_name], “Mag”) OR CONTAINS([CONTACT.recent\_conversion\_event\_name], “ELA”), [CONTACT.recent\_conversion\_event\_name], NULL))