Converting text to number

I have a dropdown column with categories that I want to convert to numbers in another column.

For example, if the value in the dropdown column is "REPORT", then I want the other column to be the number "12". If the value in the dropdown column is "GO BACK", then I want the other column to be the number "5", etc.

I have three values in the dropdown column that I can select from. Based on what value I choose, I then need a formula to convert each value to a number in the subsequent column.

What formula(s) can I use to do this?

Find more posts tagged with

Accepted answers

All comments

Paul H

Nested IF

=IF(Dropdown@row = "REPORT", 12, IF(Dropdown@row = "GO BACK", 5, IF(Dropdown@row = "THIRD OPTION", 2)))

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.