Formula to count the number of characters after a symbol

Hello. I am attempting to write a formula that will count the number of characters that follow a "-", and use the resulting number to determine if the type should be a "PO" or a "SWA" using an IF statement.

I found a formula that will pull those characters following the "-", but it just gives me the actual 2 numbers following the dash, what I need to write the formula is:

IF (PO/SWA No@row) = 2 characters, "PO", otherwise "SWA"


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!