Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Turn text into web-safe strings

Topic Labels: Formulas
Solved
Jump to Solution
623 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

See Solution in Thread

2 Replies 2

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: