How to remove last character in a concatenation

Options

I have a series of columns concatenated, separated by _ (so it looks like "A_B_C_D_E_...")

Some all columns after E are optional.

The end result means some concatenations end in "_"

I think a helper column might be needed, in which case the formula would be something like that solves for 'if row ends in "_", remove "_" - but I can't seem to get it to work.

Anyone know how to solve this seemingly simple need? Thank you!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!