Custom formulas

You can create a new value out of existing field values, similar to what you can do in a spreadsheet. There are three options for formulas:

Roll-up

A roll-up is the sum of different field values.

Example

A roll-up formula is created using Insights and Votes as inputs.

Insights

Votes

Roll-up

5

8

13


Weighted Score

A weighted score helps understand the value of an idea relative to other ideas in the project using normalization.

What is normalization?

Normalization is an operation that takes all field values across all ideas in a project.

  • 0 is taken as the minimal value. Alternatively, we take the lowest number if you are using negative numbers.

  • 100 is the highest field value.

  • All values are then plotted based on their relative value between the lowest and 100.

Examples

In the following example, we give a weighted score based on a single rating field. A rating of 5/5 equals 100, and 4/5 equals 80.

 

Rating field

Weighted score

Idea 1

100

Idea 2

80

You have positive and negative numbers

If you have both positive and negative numbers, the smallest number will be used as the minimal value.

 

Field

Weighted score

Idea 1

5

100

Idea 2

1

60

Idea 3

-5

0

If you only have negative numbers

If you only have negative numbers, the highest negative number is used as the maximum value.

 

Field

Weighted score

Idea 1

-5

0

Idea 2

-2

66

Idea 3

-1

100

If you only have positive numbers

If you only have positive numbers, 0 is the minimum value.

 

Field

Weighted score

Idea 1

6

100

Idea 2

3

50

Idea 3

2

33

Formulas

We have 2 cases:

  1. We only have positive weights defined - we wind up with a normalized sum of all normalized field values multiplied by their weights.

  2. We have at least one negative weight, and the calculation is done by dividing the normalized sum of all positive inputs’ normalized field value multiplied by their weights by the normalized sum of all negative input’s normalized field value multiplied by their weights.

Weighted score with negative inputs that sum to 0 will output nothing.

 

Write Your Own

You can write your own formula using a simple expression language:

Data Type

Example

Notes

Number

10 , 3.5

Scientific notation and negative numbers aren’t supported.

Field

{Goal impact}

Internal spaces are preserved, but leading and trailing spaces are removed.

Operator

Example

Notes

+

{Goal Impact} + 10

Addition

-

{Goal Impact} - {Effort}

Subtraction

*

{Num data points} * 3

Multiplication

/

1 / {Effort}

Division

 

Additional Help