Can someone help with following formula - need to extract value


Hoping someone could assist me with creating a formula that would allow me to get specific value from a field.

Our system gives us the Description field which contains data we want to use to further separate our data. I have tried various formulas but I run into issues since the numeric part can be 1 to 3 digits. Only an empty space separates the text I want to pull which is the field labeled What I want.

Thank you in advance for your help!

Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Answer ✓

    Try this:

    =IF(CONTAINS("Return", Description@row), "Return", IF(CONTAINS("Special", Description@row), "Special", IF(CONTAINS("Standard", Description@row), "Standard")))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!