Need a formula to take a filename and alter the text

kpierson109 ✭✭✭
edited 06/15/23 in Formulas and Functions

I need a formula that will take a filename and then remove the underscores and replace with periods and make the text lowercase. I am having trouble know what function to use to remove the underscores.

Filename example:


The filename always follows this rules - 2 letters_2 letters__2 letters _filename

I would need this to populate: jk.t1.l1.newfile

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!