arunsathiya - profile

arunsathiya · Dec 13, 2019

Is there a way to set column 2’s values to be a random value from Column 1? Let’s say I have 5 records. There are 5 values in Column 1. I would like to pick a random value from Column 1 and set that as a value for each record on Column 2.

arunsathiya · Jul 12, 2019

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, enha...

arunsathiya · Jul 12, 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. This fo...

User Statistics

User Activity

Random values from another column?

Replace multi-select values using formula

Re: Replace multi-select values using formula