Get the file name from a file path.

I have a column that contains file paths.
"/Shared/Users/Bob/bob.txt"

Assume there can be any amount of folders, with names of any length.
I just want an adjacent column to say "bob.txt"

I have tried to find the index of the last "/" and work with that, but to no avail.
How can this be done?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!