Formula custom fields 🛠️🛠️

We're bringing the best parts of Excel to Hive with the latest (and greatest) custom fields update. Users will now be able use custom field formulas in Hive itself, without exporting data to Excel or other tools.

For example, if you have two existing custom fields ('Cost per person' and 'Number of people') you could create a formula custom field ('Total cost') to multiply their values.

Creating a formula:

To create a new custom formula, visit your Custom Fields hub. From there, you'll see a "Formula" button.

Custom formulas will take the following structure:

field("[custom field 1]") (operator) field("[custom field 2]")

In the example above, you would define 'Total cost' by writing the following phrase in the formula field:

field("Number of people") * field("Cost per person")

Here is a full list of all formulas supported in custom field formulas.

Thank you to Shirley at Quorn Foods, Sam at Apercher, Nils at EA, and Anthony at Sirius XM for voting on this feature.