# Nested IFS in Calculated Fields **URL:** \ **Category:** HubSpot Ideas\ **Tags:** reports\ **Created:** [August 21, 2023, 3:18pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943 "2023-08-21T15:18:08Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![GrumpyHippo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/grumpyhippo/32/19298_2.png) [@GrumpyHippo](https://community.hubspot.com/u/GrumpyHippo)\ **Post date:** [August 21, 2023, 3:18pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/1 "2023-08-21T15:18:08Z")
Datasets enable the creation of some calculated fields using some (limited) Excel type formula funcionality. “Nested” IF functionality is not supported however, meaning you can can only return two values based on the property value of another fields. Binary values are hugely limiting, “nesting” IF logic would be a huge upgrade and reduce need for work to be done in Excel or other tools so more complex data can be viewed in Hubspot ---
**Author:** ![michaelb23](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/michaelb23/32/102437_2.png) [@michaelb23](https://community.hubspot.com/u/michaelb23)\ **Post date:** [January 25, 2024, 7:09pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/2 "2024-01-25T19:09:50Z")
Totally agree -- the only workaround seems like having to create dozens of different calculated properties, for what would have otherwise just been one property with a bunch of nested “If” statements. This would be a huge time saver! ---
**Author:** ![roland\_deshane](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/roland_deshane/32/102945_2.png) [@roland\_deshane](https://community.hubspot.com/u/roland_deshane)\ **Post date:** [February 14, 2024, 9:26pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/3 "2024-02-14T21:26:02Z")
+1, my formulas get unweildy because of this limitation. For example, if I want to sum all of the records that match a set of values for a given property, I have to write a separate sum(if()) statements for each value 😭 ---
**Author:** ![NKadyan](https://avatars.discourse-cdn.com/v4/letter/n/58956e/32.png) [@NKadyan](https://community.hubspot.com/u/NKadyan)\ **Post date:** [September 3, 2024, 5:44pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/4 "2024-09-03T17:44:52Z")
+1, trying to create a formula field to compare different permutations that can only be solved via nested if. Is there any suggestion on the workarounds? My issue is that the field can have three different values, and I have to check with a different field, which can also have three different values, I want to check if they’re same or changed positively or negatively. ---
**Author:** ![bCubbit](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bcubbit/32/8303_2.png) [@bCubbit](https://community.hubspot.com/u/bCubbit)\ **Post date:** [January 21, 2025, 5:23pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/5 "2025-01-21T17:23:27Z")
We could also really use this feature, even a limited nest but somehting more than 2 (if/else). ---
**Author:** ![Pineo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pineo/32/65476_2.png) [@Pineo](https://community.hubspot.com/u/Pineo)\ **Post date:** [September 5, 2025, 2:09pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/6 "2025-09-05T14:09:45Z")
+1 this feature would be great instead of creating extra workflows ---
**Author:** ![Fymi](https://avatars.discourse-cdn.com/v4/letter/f/bcef8e/32.png) [@Fymi](https://community.hubspot.com/u/Fymi)\ **Post date:** [December 4, 2025, 12:02pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/7 "2025-12-04T12:02:15Z")
+1, need this too ---
**Author:** ![KRRussell](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@KRRussell](https://community.hubspot.com/u/KRRussell)\ **Post date:** [January 12, 2026, 5:46pm UTC](https://community.hubspot.com/t/nested-ifs-in-calculated-fields/87943/8 "2026-01-12T17:46:10Z")
+1