Stumped on formula


I run a report out of our Accounting system and it has the store number included in the account number, along with what we refer to as our Sub Project number (example: NS 0046 - AE). I am trying to add a formula to Sub Project column to result in the Sub Project number (Example: row 1 = AE, row 2 = CONST). Is that possible or just wishful thinking on my part?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!