# How do I create a calculation if field using picklist values?

**URL:** <https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468>\
**Category:** Dashboards & Reporting\
**Tags:** enterprise\
**Created:** [October 1, 2024, 7:31pm UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468 "2024-10-01T19:31:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![CBabin0](https://avatars.discourse-cdn.com/v4/letter/c/9fc348/32.png) [@CBabin0](https://community.hubspot.com/u/CBabin0)\
**Post date:** [October 1, 2024, 7:31pm UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468/1 "2024-10-01T19:31:33Z")

</div>

if(([properties.hs\_analytics\_source] == “Offline sources”), “Sales”, “Marketing”)

This doesn’t seem to work and I don’t understand why. All Test Formula values resulting in a sample output of “Marketing”

I prefer to avoid a workflow if possible.

 ![CBabin0_0-1727811080004.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/5/554a9b64914ff950831a5a113b58e7f527b3894c.png)

---

<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:** [October 1, 2024, 7:37pm UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468/2 "2024-10-01T19:37:53Z")

</div>

Hi @CBabin0,

When you say “this doesn’t seem to work”, you’re checking records with an original source offline and the calculation field stays empty or does it state falsely?

Best regards

---

<div class="post-metadata">

**Author:** ![CBabin0](https://avatars.discourse-cdn.com/v4/letter/c/9fc348/32.png) [@CBabin0](https://community.hubspot.com/u/CBabin0)\
**Post date:** [October 1, 2024, 7:44pm UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468/3 "2024-10-01T19:44:33Z")

</div>

Here’s a deal report. The calculation field is “Marketing or Sales Generated”. It says Marketing when it should say sales.

 ![CBabin0_0-1727811838542.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/9/191b7b94055fd12210e3ad991566ea9e0c5b191f.png)

---

<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:** [October 1, 2024, 7:47pm UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468/4 "2024-10-01T19:47:56Z")

</div>

@CBabin0 to rule out that this is a reporting issue, have you checked the individual records that appear to be wrong?

In any case, this looks like a bug and I’d recommend flagging it directly with HubSpot support.

---

<div class="post-metadata">

**Author:** ![CBabin0](https://avatars.discourse-cdn.com/v4/letter/c/9fc348/32.png) [@CBabin0](https://community.hubspot.com/u/CBabin0)\
**Post date:** [October 7, 2024, 8:14pm UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468/5 "2024-10-07T20:14:07Z")

</div>

I appreciate the reply. I’ve sent in the bug. In general, is this type of calculation possible? I had a customer service rep last week tell me it wasn’t

---

<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:** [October 8, 2024, 4:02am UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468/6 "2024-10-08T04:02:14Z")

</div>

@CBabin0 as far as I know it should be, I don’t see why it wouldn’t. Which explanation did the customer service rep offer as to why it cannot be done?

(As you did, I insist that this is buggy behavior when things like these come up. The user interface and documentation suggest it’s possible so even if there is some technical nuance that makes it currently impossible, the product team should, in my opinion, iron it out.)

---

<div class="post-metadata">

**Author:** ![CBabin0](https://avatars.discourse-cdn.com/v4/letter/c/9fc348/32.png) [@CBabin0](https://community.hubspot.com/u/CBabin0)\
**Post date:** [October 14, 2024, 4:52pm UTC](https://community.hubspot.com/t/how-do-i-create-a-calculation-if-field-using-picklist-values/117468/7 "2024-10-14T16:52:47Z")

</div>

Hey Karsten,

Just wanted to followup with a solution here. My issue was I wasn’t using the “Internal Name” of the picklist value which was “OFFLINE” in this case.

If anyone else runs inot this issue, to solve, go to the Dropdown Select (aka picklist) field. Go to Field Type and find the Dropdown Options. You’ll see “Internal Name” there.

 ![CBabin0_0-1728924744412.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/9/89f78c8afb4fe45b4cf576e66de26188947c9508.png)