Project automatic counter

Majkoss

Hi, im working on project tracker, and i have to do the automatic number assigner for the particular projects. So there is like 20 projects that started in 2020, like 10 in 2019 and each should have number like 1_20, 2_20, 3_20 and when there's start date in 2019 there should be separate count 1_19, 2_19 and so on. Is there anyway to write this formula?

BullandKhmer

Do you have a column showing the year the project started?

Any chance you can share the sheet.

Andrée Starå

Hi @Majkoss

I hope you're well and safe!

Are all projects in the same sheet or one project per sheet?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Majkoss

it is a list of projects

Majkoss

so it looks like thisand i want the project number to be automatically made based on the year from the date of issue. Right now in the screenshot it is written manually.

Majkoss

also if possible it could define the project number depending from the type of project; so if its toothbrush the the counting should be separated from the mouthwashes and from toothpastes

Majkoss

is this possible to make this?