Turn text into web-safe strings

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

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

2 Likes

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