Formula Term convert to a given value

Annick

I have a Program stage column that has 8 different stage option. In another column I would like to create a formula that based on the @row stage a given number would be indicated. Example: Stage 1 would give 0.2, Stage 2 would give 0.3 and so on. I can use the IF but after two Program stage the formula stops working. The below works only with the two

=IF([Program Stage]@row = "Marketed", "0.1", IF([Program Stage]@row = "Preclinical", "0.3"))

Any other formula option I can use? Or how do you I need to modify this one to add additional option with values?

MedaUser

Hi @Annick,

I'm curious as to why your formula isn't working for you. I've built some pretty complex IF formulas that worked, so I wonder if you missed a comma or something somewhere. Would you mind providing the options with scores, and I'll take a stab at writing it out for you and testing in my own environment? Something like below.

• Marketed = 0.1
• Preclinical = 0.3
• etc.