Sequential project number based on team and product name?

GMartin · 2022-01-11T21:48:43+00:00

There was an error rendering this rich post.

GMartin

Hello Smart community,

Trying to achieve what seems many are also working on: sequential project numbers.

Below, the team is a drop down with options, the product name is manual and the result is what's below.

Trying to achieve the following:

UXR00 ending with a sequential number, e.g. 001... n

If same team, increase 1, e.g.

UXR002-GT-RTW

UXR003-GT-RTW

If different team, look for last number and increase thereafter, e.g.

UXR001-EE-POS

UXR002-EE-PPT

Please help?

Thanks

Screen Shot 2022-01-11 at 1.41.40 PM.png

Screen Shot 2022-01-11 at 1.42.02 PM.png

Find more posts tagged with

Accepted answers

Devin Lee

Hey @GMartin

Create another column for the Number and insert the formula below into it. Unfortunately, it can't be a column formula because that's not supported for whatever reason.

=IF(AND(ISBLANK([Product Name]@row), ISBLANK(Team@row)), "", COUNT(COLLECT([Product Name]$1:[Product Name]@row, Team$1:Team@row, Team@row, [Product Name]$1:[Product Name]@row, [Product Name]@row)))

Then in the Project Number column use this formula. This one can be a column formula.

=IF(Number@row = "", "", "UXR" + (RIGHT(1000 + Number@row, 3)) + "-" + Team@row + "-" + [Product Name]@row)

All comments

GMartin

Worked perfectly fine! Thank you SO much for the quick reply.

Devin Lee

Hey @GMartin

Create another column for the Number and insert the formula below into it. Unfortunately, it can't be a column formula because that's not supported for whatever reason.

=IF(AND(ISBLANK([Product Name]@row), ISBLANK(Team@row)), "", COUNT(COLLECT([Product Name]$1:[Product Name]@row, Team$1:Team@row, Team@row, [Product Name]$1:[Product Name]@row, [Product Name]@row)))

Then in the Project Number column use this formula. This one can be a column formula.

=IF(Number@row = "", "", "UXR" + (RIGHT(1000 + Number@row, 3)) + "-" + Team@row + "-" + [Product Name]@row)

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.