Auto Number Formatting

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?

Find more posts tagged with

Forms

Sales

Manufacturing

Sheets

Contacts

Formulas

Reports

Services

Integrations

Marketing

Support

Dashboards

IT & Operations

Product Development

Project Management

Account and User Management

Comments

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

lisarae723

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å

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

lisarae723

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

Andrée Starå

Excellent!

Let me know how it goes!

Best,

Andrée

lisarae723

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

Number Format.png

lisarae723

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å

Ta-Daa!

You're welcome!

Best,

Andrée

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, andree@getdone.se)

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…