Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Script for combining information from multiple single select fields

Topic Labels: Extensions Formulas Sync
Solved
Jump to Solution
326 1
cancel
Showing results for 
Search instead for 
Did you mean: 
GSPteam
4 - Data Explorer
4 - Data Explorer

Hello community! 

I have 15 separate single select fields with the possible answers of: 

1. Firsts

2. Second

3. Third

4. No Preference 

5. I do not select this UWC 

I would like to create the individual columns "First" "Second" "Third" "No preference" and have the answers filter into these columns (rather than having all 15 individual columns open). 

Does anyone have any script suggestions to make this possible? 

The 15 single select column titles are: 
- Atlantic, Changshu, Costa Rica, Dilijan, East Africa, ISAK, LPC, Maastricht, Mahindra, Mostar, Pearson, RCN, Thailand, USA, Waterford Kamhlaba 

 

Esentially, if someone selects:

- First: Atlantic

- Second: Dilijan

- Third: Costa Rica

- I do not select this UWC: all other columns 

I want to be able to see the Atlantic in column "first", Dilijan in column "second" and Costa Rica in column "third" so I an hide the 15 individual columns but still see the information I need more succinctly. 

Any help would be greatly appreciated! 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I'd recommend a formula instead:

Screenshot 2024-09-17 at 9.41.10 AM.png

Here's the formula for 'First', and you'd update it with the rest of your countries:

IF(
  Atlantic = "First",
  "Atlantic"
) &
IF(
  Changshu = "First",
  "Changshu"
) &
IF(
  {Costa Rica} = "First",
  "Costa Rica"
) &
IF(
  Dilijan = "First",
  "Dilijan"
)

Link to base

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

I'd recommend a formula instead:

Screenshot 2024-09-17 at 9.41.10 AM.png

Here's the formula for 'First', and you'd update it with the rest of your countries:

IF(
  Atlantic = "First",
  "Atlantic"
) &
IF(
  Changshu = "First",
  "Changshu"
) &
IF(
  {Costa Rica} = "First",
  "Costa Rica"
) &
IF(
  Dilijan = "First",
  "Dilijan"
)

Link to base