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

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 B

Project C

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

Is there a formula that can solve for this?

Thank you in advance!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Insert an auto number column (called "Auto") with no special formatting. Then use this formula in a separate column:

=COUNTIFS(Auto:Auto, @cell <= Auto@row, [Project Name Column]:[Project Name Column], @cell = [Project Name Column]@row)

PCG

@Paul Newcome This worked perfectly, thank you so much!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.