Alphanumeric column add 1

Options

Hi All,

Anyone know how to add 1 in the alphanumeric column?

For example:

ABC-001

ABC-002

ABC-003

Excel formula is =LEFT($E$2,4)&TEXT(RIGHT(E7,3) + 1,"000"). Anyone know what's the formula in Smartsheet?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!