Formula Term convert to a given value

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?

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.