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.

formula to extract info based on custom fields

For example, you could provide the following values to the field and name placeholders in the formula.

example of custom field extraction

Calculate the sum of the values on a column

Use the formula below to sum the values on a column.

Formula to sum up the values in a column

Calculate total vendor costs

Use the formula below to calculate the total costs for each vendor quote in a project.Formula for calculating total vendor costs