RAID Log - Numbering
I have a column entitled 'RAID' with dropdown options: Risk, Action, Issue, Decision, and a column entitled 'Auto' which is a column type Auto Number starting at number 1 (no prefix or suffix). This Smartsheet has a form. When a user completes the form, they will select 1 of the 4 RAID drop downs, they submit the form and the entry get's logged at the top of the Smartsheet where the 'Auto' column will automatically number that row. For each RAID option logged, regardless of the sequencial number assigned by the Auto column, that I have a seperate column that numbers it... for example, if user X logged 2 Risks and 2 Issues the system will assign these R1, R2, I1 and I2 regardless of the number assigned by the Auto column.
Answers
-
Do you have a question, or do you have a solution that you are wanting to share?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Apologies Paul, I'm in need of a solution.
-
Ok. Try inserting an auto-number column with no special formatting (called "Auto" in this example). Then you can use something like this:
=LEFT(RAID@row) + COUNTIFS(Auto:Auto, @cell<= Auto@row)
If you need the numbers zero filled (R001, R002, R003, etc.), it would look like this:
=LEFT(RAID@row) + RIGHT("000" + COUNTIFS(Auto:Auto, @cell<= Auto@row), 3)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!