Skip to main content

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.

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 🙂

Reply


Terms & Conditions