Auto Number Formatting

lisarae723lisarae723 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
03/21/19 Edited 12/09/19

Hello everyone:)

I currently have a sheet populated via a web form. There are several people assigned to tasks.

My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. 

Lets say I'm assigned a task, the number format would show as: LS-XXXX-268790

Your thoughts?

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Lisa,

    You can only have one auto number column so my suggestion would be to have one or more helper columns

    Would that work?

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • lisarae723lisarae723 ✭✭✭✭✭

    Hi there!

    You are always so helpful:) 

    Im not sure that I understand how that would work. Are you suggesting that I add columns with formulas to combine the 2 sets of information? (sorry, Im not on my "A" game today)

     

    Lisa

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    I'm always happy to help!

    Yes, exactly. One column to check who the task is assigned to and that would result in the initials. The second column would combine the initial with the auto number.

    Would that work?

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • lisarae723lisarae723 ✭✭✭✭✭

    That sounds like it will work. I will give it a try. Thanks so much.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Excellent!

    Let me know how it goes!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • lisarae723lisarae723 ✭✭✭✭✭

    Ta-Daa! It worked. Thanks for always being ready to help.

    Number Format.png

  • lisarae723lisarae723 ✭✭✭✭✭

    Hi there!

    Although my formula is working fine when working within the sheet itself, if a new row is populated via a web form, the formula will not populate. Do you think the 2nd portion of my formula in the Row ID column is the culprit? It is set to give a sequential number format. Entry4 +1, Entry4+2, Entry4 +3 etc??? 

    (2 blank rows with the formulas were on the sheet before the web form entry- Screenshot attached)

    =Format2 + "-" + Entry4 + 1 + "-" + Ticket2

    Any Suggestions?

    Formula Not Populating.png

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Ta-Daa! laugh

    You're welcome!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    I'd be happy to take a look!

    Can you share the sheet? That would make it easier to help. (share too, [email protected])

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.