Skip to main content
Solved

Replace multi-select values using formula

  • July 12, 2019
  • 2 replies
  • 30 views
A

I am looking for a way to use the REPLACE() formula function to replace values in a Multi-select column with different values on a new column.

For example:

The original column contains column Type of question with multi-select values bug-report, enhancement.

Can we create a new column called Type of question (new) with the corresponding new values: bug-report-new and enhancement-new?

Best answer by Kamille_Parks11

I would use the SUBSTITUTE() function instead: SUBSTITUTE({Type of Question},'bug-report','bug-report-new')
^ This simple formula will work, but you’ll have to nest a bunch of SUBSTITUTE()s to account for each multi-select option possible.

So try something like this: IF({Type of Question},SUBSTITUTE({Type of Question},',','-new,')&'-new')
^ that formula will add a ‘-new’ to the end of any field option you have., which is handy if you have quite a few or will need to add more options in the future since this formula will account for new options automatically/

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

I would use the SUBSTITUTE() function instead: SUBSTITUTE({Type of Question},'bug-report','bug-report-new')
^ This simple formula will work, but you’ll have to nest a bunch of SUBSTITUTE()s to account for each multi-select option possible.

So try something like this: IF({Type of Question},SUBSTITUTE({Type of Question},',','-new,')&'-new')
^ that formula will add a ‘-new’ to the end of any field option you have., which is handy if you have quite a few or will need to add more options in the future since this formula will account for new options automatically/

A
Justin_Barrett
A
  • arunsathiya
  • Author
  • New Participant
  • July 13, 2019

I would use the SUBSTITUTE() function instead: SUBSTITUTE({Type of Question},'bug-report','bug-report-new')
^ This simple formula will work, but you’ll have to nest a bunch of SUBSTITUTE()s to account for each multi-select option possible.

So try something like this: IF({Type of Question},SUBSTITUTE({Type of Question},',','-new,')&'-new')
^ that formula will add a ‘-new’ to the end of any field option you have., which is handy if you have quite a few or will need to add more options in the future since this formula will account for new options automatically/


I would use the SUBSTITUTE() function instead: SUBSTITUTE({Type of Question},'bug-report','bug-report-new')
^ This simple formula will work, but you’ll have to nest a bunch of SUBSTITUTE() s to account for each multi-select option possible.

This format helped, thank you! I ended up nesting the formula for my replacements. :white_check_mark:

Terms & ConditionsAccessibility statement