Back to all product releases

New filter and formula functions updates

Sheanee Michaud
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() and split() 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) .

Share this post