Project automatic counter
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?
Answers
-
Do you have a column showing the year the project started?
Any chance you can share the sheet.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
it is a list of projects
-
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.
-
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
-
is this possible to make this?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!