Useful workspace formulas in the legacy reporting module
Consult the list of useful formulas that you can use in workspaces.
Extract a value as an independent column
If you have a cell with multiple values, you can extract one of the values as a separate column, so that you can sort and group information by that column.
For example, if you have 3 custom fields and you need to group your information by one of these custom fields, you can extract the custom field as an independent column.
Use the formula below to extract a custom field value as a separate column in the data set.
For example, you could provide the following values to the field and name placeholders in the formula.
Calculate the sum of the values on a column
Use the formula below to sum the values on a column.