Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 16, 2024 09:26 AM
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!
Solved! Go to Solution.
Sep 16, 2024 06:42 PM
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"
)
Sep 16, 2024 06:42 PM
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"
)