Formula to auto-number rows for multiple projects within a single sheet

Options
PCG
PCG ✭✭
edited 06/22/22 in Formulas and Functions

Hello,


I'm looking to a formula that will auto-number rows for multiple projects within a single sheet. For example, I have rows for Project A, Project B, and Project C in the same sheet:

Project A

Project A

Project A

Project B

Project B

Project B

Project B

Project C

Project C

I want my auto-number column to return the following:

1

2

3

1

2

3

4

1

2


Is there a formula that can solve for this?


Thank you in advance!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!