Build formula for RICE score

[Itayett]

Hi
I’m trying to create a formula to calculate the RICE scoring system.
I want to be able to populate columns with numbers and then the formula will give me the final score, I’ll explain:

Ive created columns named Reach, Impact, Confidence and Effort
and the logic is : Rach X Impact X Confidence / Effort =

It seems like my formula is not working - what as i missing?

[GCavin]

Hi @Itayett,

Why the = at the end?

[Itayett]

@GCavin

I removed th = at the end, but it still not working.
What am i missing?

Thanks

[GCavin]

In a case like this, you’ll need to test. Item by item.
{Reach#Count}
{Reach#Count}*{Impact#Count}
{Reach#Count}*{Impact#Count}*{Confidence%#Count}
etc. until you reach the culprint.