Skip to main content

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! 

I'd recommend a formula instead:

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 

Reply


Terms & Conditions