Help

Turn text into web-safe strings

Topic Labels: Formulas
Solved
Jump to Solution
1036 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Adam_Kramer
6 - Interface Innovator
6 - Interface Innovator

Hey guys,

I am wondering how I would go about importing text from another field like “Diamond Plus” and translating it into “diamond-plus”?

Any way to do this without just building a really long IF statement?

Thanks so much,
Adam

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

LOWER(SUBSTITUTE({Field Name}, ' ', '-'))
^ that formula replaces spaces with a dash, then sets all letters to lowercase.

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

LOWER(SUBSTITUTE({Field Name}, ' ', '-'))
^ that formula replaces spaces with a dash, then sets all letters to lowercase.

Thank you so much! Works like a charm :slightly_smiling_face: