Advanced conditional functions for calculated properties

What it is

Two new functions for calculated properties. ifs: multiple conditions in one function, ifs(condition1, value1, [condition2, value2], ...), up to 100 condition/value pairs (e.g., ifs([properties.amount] > 5000, "High", [properties.amount] > 200, "Medium", [properties.amount] > 0, "Low")). coalesce: fallback values when a property is empty, coalesce(value1, value2, ...), up to 100 arguments (e.g., coalesce([properties.firstname], [properties.lastname])).

Why it matters

Build more complicated conditional formulas and provide fallback values in a way that is easier to read.