# Formula fields not working with if clauses? **URL:** \ **Category:** CRM\ **Tags:** reports, crm, sales\ **Created:** [May 27, 2025, 8:08am UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386 "2025-05-27T08:08:01Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![SZamblau](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@SZamblau](https://community.hubspot.com/u/SZamblau)\ **Post date:** [May 27, 2025, 8:08am UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386/1 "2025-05-27T08:08:01Z")
Hello I have created this formula, I want it to show $1,000,000 when X or Y are selected as the deal owners, it doesn’t work when I test it, please advise why as the support team already confirmed the formula is correct and it does say “no issues” ![Screenshot 2025-05-27 at 11.06.59.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/e/5e92f87187ade529f5c364247de77697a8751955.jpeg) ---
**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 27, 2025, 8:09am UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386/2 "2025-05-27T08:09:31Z")
Hi @SZamblau, I’m not sure HubSpot expects the user name here, but probably the user ID. Can you try filtering for the ID instead? See a below quick test that returned the ID for my own user: ![karstenkoehler_0-1748333530058.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/a/6a57f112fadd2b5963c7e4f3d040fceaf85e73b3.png) In other words, the if statement will always evaluate as false at the moment. Best regards ---
**Author:** ![SZamblau](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@SZamblau](https://community.hubspot.com/u/SZamblau)\ **Post date:** [May 27, 2025, 8:29am UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386/3 "2025-05-27T08:29:16Z")
Hi @karstenkoehler , I did the ID switch but I still might be missing something as it still does not work, can you please take a look? ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/f/8f56c43c3ffae151587a069bc43d154be4bbe85d.png) ---
**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 27, 2025, 9:11am UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386/4 "2025-05-27T09:11:57Z")
@SZamblau when I test it, it works for me: ![karstenkoehler_0-1748337057698.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/1/216172823a501b71928bb32b740f7c135b953d0a.png) Could you please share a screenshot of your entire configuration of the property, including type, output, format etc? Have you made sure you’re referencing the right ID? ---
**Author:** ![SZamblau](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@SZamblau](https://community.hubspot.com/u/SZamblau)\ **Post date:** [May 28, 2025, 1:31pm UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386/5 "2025-05-28T13:31:49Z")
![Screenshot 2025-05-28 at 16.25.59.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/0/5012ef951ee0513622d1b3c7003cc28909933b4b.png) Hello, please see here the screenshot requested, yes I am using the user id from the user table, and I am creating this field on the deal object , please see second screenshot for confirmation: ![Screenshot 2025-05-28 at 16.28.49.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/f/3fd922b2e22fb17cd5f2e18caa19cd4cc5ccc152.png) In the last screenshot you can see the output, it is 0 when it should be 1000000 formated as USD currency: « ![Screenshot 2025-05-28 at 16.31.08.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/f/f6a976ec02cb8e5fa2609c43e2a06c4b117a969e.png) Thank you ---
**Author:** ![SZamblau](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@SZamblau](https://community.hubspot.com/u/SZamblau)\ **Post date:** [May 29, 2025, 12:09pm UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386/6 "2025-05-29T12:09:52Z")
Hi @karstenkoehler any updates on the above? , i have tested it multiple times since yesterday but it doesn’t work. ---
**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 29, 2025, 12:14pm UTC](https://community.hubspot.com/t/formula-fields-not-working-with-if-clauses/133386/7 "2025-05-29T12:14:11Z")
@SZamblau the only difference I’m spotting would be the = vs == although I can’t make sense of it – have you tried adjust as shown in my screenshot?