Robust Formula Field

[Nick_Trendline]

It would be great to be able to create custom formula fields (properties) in Hubspot like you can in Salesforce.  I know of the existing calculated property option, but it's quite limited (only used on number fields).

The new formula field would allow a user to create a custom field based on expressions like Date/Time (e.g. WEEKDAYDIFF(date1, date2)), Average (e.g. AVERAGE(number1, number2[, ...])), Text (e.g. CONCAT(string1, string2[, ...])), and other (e.g. IF(condition, trueExpression, falseExpression)).

[JoshAtMNCEE]

text formulas like LEFT, RIGHT would help me right now.

[magda_kas]

It would be very helpful for me right now to also be able to nest the formulas, e.g. 

 IF(condition1, trueExpression1,  IF(condition2, trueExpression2, falseExpression))