We occasionally release new versions of the formula system to deliver new features and improved functionality. These updates help ensure you have access to the latest capabilities and the best possible experience. In some cases, files built with an older version may need small adjustments to stay fully compatible.
The following instructions shows how you can see what version a Workiva document, spreadsheet, or presentation is using.
To check your formula version:
- In the Edit toolbar, click Properties.
- Hover over Document, Spreadsheet, or Presentation (depending on your file type) and select General.
- In the General tab, view the Formula Version section. In here, you can see what version is being used for the file.
Note: To upgrade your formula version, contact support or your CSM.
Formula Version 6 information
This is the current version.
Updates
- Formulas that compare ranges to single values and then add or multiply them, will see significant performance improvements. This is commonly used with FILTER.
Minor changes/Bug fixes
- Fixed an issue where cells with Date, Period, and Text value formatting could be affected by the document default Shown In if formulas were calculated under As Displayed.
- Fixed data validations resulting in a single option displaying zero options.
- Fixed some formulas resulting in the text -0 when it should be 0.
- Fixed a scenario in XMATCH where certain characters preceding a wildcard would cause XMATCH to not find and matches when it should have.
- Fixed wildcards (?, *) not being escaped in XMATCH and XLOOKUP when using the standard wildcard escape (~).
- Prevent Entered In from affecting certain array function parameters, like the
sort_orderparameter in SORT.
Formula Version 5 information
Updates
- 17 new array formulas
- Spill capabilities
- Enable array syntax
Minor changes/Bug fixes
- Fixed a bug in the COUNTIF and COUNTIFS functions when searching over an unbounded range (e.g. A:A) with a criteria that is satisfied by empty.
- Fixed a bug in the AND/OR functions when searching a range that has text values that can't be parsed as boolean.
- SUBTOTAL, HLOOKUP, VLOOKUP now more reliably propagate errors that are directly passed as an argument.
- IF, IFS, CHOOSE, INDEX now return a reference instead of the cell's value.
- COUNTBLANK and TEXTJOIN can now search for blanks and in unbounded range.
- Improvements to the validation logic used to ensure ranges given to IF and IFS functions have compatible sizes.
- Small tweaks to function argument validation to better match other spreadsheet applications. (example: VLOOKUP’s
table_arrayparam now requires a range/array). - Many functions were updated to treat single cell references the same as range references for consistency. (example: SUMPRODUCT when given a single cell reference to an empty cell).