Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Help with formula to capture text to the right of /

Hello there, I am needing some assistance with a formula to pull text to the right of the / in my column and move it to my HELPER column. Thanks for the help.

Best Answer

  • ✭✭✭
    edited 06/19/24 Answer ✓

    The following formula should work as a column equation. I think there are other formulas you can use as well but this one is fairly straight forward.

    =RIGHT([Recipient contact name]@row, LEN([Recipient contact name]@row) - FIND("/", [Recipient contact name]@row))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions