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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!