In this release:

  • New in formula rules: IFERROR and IFNA: IFERROR(value; value_if_error) returns the second value when the first one fails – division by zero, a lookup that finds nothing, NaN – and IFNA replaces only the "not found" of XLOOKUP, XMATCH, MATCH and LOOKUP, as Excel’s #N/A. Example: IFERROR(XLOOKUP(A2; Table1.A2:A9; Table1.C2:C9); "-").
  • Fix: formulas with arithmetic before a comparison, such as A2 - B2 >= 0 or x * 2 > 10, failed with "Specified priority is not defined". They work now.
  • Compatibility: Confluence Data Center 9.2 – 11.0, tested on 9.2, 10.2 and 11.0.