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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!