Translate Cell value to a specific number
Hello,
My Master sheet has one column called "Portfolio,". Each cell in that column *may* contain multiple values - up to 5 choices (as shown below)
I'd like a new column that would convert those "names" to a specified number (ie. 1,2,3,4,5)
for example (using below as an example), it would translate to....
1
1,2,3,4,5
1,2,3
1,2,3,4,5
1,3
Do I need to do this using a report, or help column?
thanks, tons in advance,
Best Answer
-
I would suggest a nested SUBSTITUTE.
=...............SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Portfolio@row, "Rail Development & Compliance", "1"), "Network Operations - Rail", "2"), ..................
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
I would suggest a nested SUBSTITUTE.
=...............SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Portfolio@row, "Rail Development & Compliance", "1"), "Network Operations - Rail", "2"), ..................
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hey Paul,
you nailed it...
thank you, kindly (again)....
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!