So I have a Single Option field, where I say an item is an Opportunity or a Threat.

Then I have another Single Option Formula Field where I give an importance to the item. From Very Important to Not Important.

I have a Formula Field where depending on Importance chosen, I get a NUMBER result from 10 to 0.

Then I created a formula field to give a separate rating for Opportunities and Threat items.

I tried it two different ways. None worked.

FIRST

Opportunity Rating

if({{classificacao}}=“Oportunidade”,“{{pontimport}}”,0)

below… first item is opportunity… thus it matches the conditional, so result should be that 10 from PontImport. However, I am getting a ZERO. The second item is not opportunity, so end result is correct (zero)

SECOND: second method uses the ClassOp and ClassAm columns. This method also failed.

In this method, ClassUp checks if Classificação is Opportunity and gives me 1 if yes, 0 if no.

And ClassAm does the same, but if Classificação is a Thread (Ameaça)

Then, at Pontuação Oportunidade, I simply had a multiplication between ClassOp and PontImport… thus, if Oportunidade, the formula in the first record would be 1 * 10 = 10… if threat, formula would be 0 * 10 = 0.

{{classop}}*{{pontimport}}

However, I am getting a BLANK result when using this other method