Back to all product releases
New filter and formula functions updates
Sheanee Michaud
Product Expert
All-in-one
Analytics
Reporting
Foundations, Plus, Enterprise
Core Update
In addition to inclusive filters, filter functions now support a strict "is greater than" or "is less than" filter. This allows for more precise control of excluding a specific value when filtering.

We've also added new functions to Formula Fields:
today()to support current date calculations, instead of having to manually enter the current date.substring()andsplit()make it easier to parse text values (for example, splitting a "First Last" field).- multi-condition
if()functions support multiple condition/value pairs and nesting. For example,if(cond1, value1, cond2, value2, elseValue).