Status: Idea Submitted
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
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!
+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 
+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.
We could also really use this feature, even a limited nest but somehting more than 2 (if/else).
+1 this feature would be great instead of creating extra workflows
+1, need this too
+1