Custom Auto Numbering Function


Hi! New Smartsheet user here, appreciate any help and guidance. I'm looking to create a formula to build a custom auto-number function. I'm including a screenshot for reference. I'd like to automate the Project ID column. Where the project ID is YEAR - CLIENT - CLIENT PROJECT NUMBER.

Is there a formula out there that would work for this? Thank you very much for taking the time to review.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would just need to rearrange the sections.

    You can see in the formula there are two instances of

    + "-" +

    Those are your delimiters. Everything to the left of the first one is what outputs the "R". Everything to the right of the second one outputs the "20", and everything in between outputs the count.

    So right now the formula is going

    left + "-" + middle + "-" + right

    You want

    right + "-" + left + "-" + middle


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!