How to Delimit Cells in Formulas

Hi,

I have two columns:

I want the second column to be delimited (trim) at just the release version. Unfortunately, I'm not super experienced with formulas.

While I was able to get this formula to work for 1 row,

it's easy to see how this isn't scalable. I looked for instructions on trimming and delimiting but all the examples I saw had words that you could filter out.

I tried looking for some wildcard functionality but I couldn't find it. Can someone help me with a formula that will strip everything out of the first column except the last 4 characters for placement in the second column?

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    Hi There,


    You can have a formula in AFO Version and make it a column formula. The formula would be "=Right([Primary Column]@row, 4)". This formula will pick up the last 4 characters of the text in your primary column.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    Hi There,


    You can have a formula in AFO Version and make it a column formula. The formula would be "=Right([Primary Column]@row, 4)". This formula will pick up the last 4 characters of the text in your primary column.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!