A recent release to the Workiva platform included improvements to the following products and features. You can learn more about each item in the section below.
UPDATE 10/7: Revised "Note" paragraph to complete sentence.
UPDATE 10/20: Added note on Charts.
Charts
Update: Tooltip appears correctly on Combo Charts
Spreadsheets
New: Support for array formulas, Support for array spilling, and 17 new functions
Charts
Tooltip appears correctly on Combo Charts
When hovering the mouse over the bar or column on a combo chart the tooltip now displays below the label so that both pieces of information are visible, as shown below.
Spreadsheets
Array Formula support, Spill, and 17 new functions
We're thrilled to announce that our platform now supports dynamic array formulas, which is capable of automatically spilling results into adjacent cells. This powerful update allows you to write one formula to instantly sort, filter, and perform complex calculations on entire ranges of data, without ever having to drag and fill again.
In addition to arrays formulas and spill, we’ve also added 17 new functions to help you better utilize arrays in Workiva. Here are the new functions:
- CHOOSECOLS — extract specific columns from a range or array.
- CHOOSEROWS — extract specific rows from a range or array.
- COLUMNS — determine the number of columns in a specified array or reference.
- DROP — remove a specified number of rows or columns from the beginning or end of an array or range.
- FILTER — extract rows from a range or array that meet specified conditions.
- HSTACK — to horizontally stack multiple ranges or arrays into a single range.
- MMULT — calculate the matrix product of two arrays. The MMULT function returns the product of two arrays as a matrix.
- ROWS — determine the number of rows in a specified array or reference.
- SEQUENCE — generate a list of sequential numbers in an array.
- SORT — dynamically sort a range or array by one or more columns in ascending or descending order.
- TAKE — extract a specified number of rows or columns from the beginning or end of a range or array.
- TOCOL — an array as a single column.
- TOROW — an array as a single row.
- TRANSPOSE — convert a vertical range of cells to a horizontal range, or vice versa.
- TEXTSPLIT — split text strings into rows and columns based on specified delimiters.
- UNIQUE — extract a list of unique values in a list or range. Values can be text, numbers, dates, times, etc.
- VSTACK — vertically stack multiple ranges or arrays into a single range
Please note that to use the new functionality, your document must be using the latest Formula Version (Formula Version 5). You can check which formula version your document is on by reviewing the Properties section in your Spreadsheets, Document, or Presentation. To learn more on how to check your formula version, read Document and section properties.
By default, the majority of documents will be on Formula Version 5. However, if your document is not on Formula Version 5, you can contact support to request to have your file upgrade to the newest formula version.
Note: Upgrading your document to Formula Version 5 may change how formulas evaluate.
Minor Changes / Bug Fixes
In addition to the introduction of arrays, spill, and 17 new formulas, Formula Version 5 also brings some minor changes and bug fixes:
- Fixed a bug in the COUNTIF(S) 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.
- Certain functions now more reliably propagate errors that are directly passed as an argument. (SUBTOTAL, HLOOKUP, VLOOKUP)
- Certain functions that would return a single cell reference now actually return a reference instead of the cell's value. (IF, IFS, CHOOSE, INDEX)
- Certain functions that couldn't search for blanks in an unbounded range now can do so. (COUNTBLANK, TEXTJOIN)
- Improvements to the validation logic used to ensure ranges given to *IF(S) functions have compatible sizes.
- Small tweaks to function argument validation to better match other spreadsheet applications. (example: VLOOKUP’s
table_arrayparameter 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.)
To learn more, see this Workiva Support page: Use array formula functions in spreadsheets.