Create filename from column

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

I need a formula to create a name from a column that looks like this: jk.t1.t3.filename

The following formula works for certain files.

=LOWER(SUBSTITUTE(Filename@row, "_", "."))

I need to remove a word and underscore from specific items to create the filename.

Ex item: JK_T1_T3_Test_FileName

I would want the formula to remove "Test_" from these items.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!