# Numbering rows

edited 09/20/20

Hi, I wanted to know if its possible to have the entry number as the Function + RAID item(R,A,I,D) + number. For example, if its risk 1, in function 1, I want the entry number as "Function 1. R.1" and if its Issue 3 in function 3, the entry number should be displayed as "Funciton 3. I.3" and so on. Please help. Thanks! (Screenshot is attached)

Tags:

Would you mind clarifying what you want the number to be, as part of that formula?

You can add together different cells by using the + icon in a formula, including adding in text such as " . " as well. If your number at the end is just associated with what row has come in, you could include an auto-number column into the sheet and include this number in your formula, like so:

=Function@row + ". " + RAID@row + ". " + [Row ID]@row

Let me know if I've misunderstood your question or if I can help further.

Cheers,

Genevieve

• One solution I use similar to above is:

=function@row + "." + RAID@row + "." + RIGHT(1000 + COUNTIF(RAID\$1:RAID@row, RAID@row), 3)

This gives you a numbering system that matches each RAID type. Either is correct - it comes down to what question you are trying to answer!

Let me know if I can be of further assistance.

Respectfully,

J

Jeff Anderson

Sevan Technology

Smartsheet GOLD Partner

• Hi Jeffrey/Genevieve,

Thanks for your help. I guess I haven't explained what I need correctly. I apologize. What I am looking for is for the R,A,I,D items to be named as per the functions- i.e. if its the 'first' R in Funciton1 , the result should be - Function 1. R.1 and if its the 'third' A in function 4, the result should be - Function 4. A.3

@Genevieve P : I will try to explain using Jeff's solution.

@Jeffrey Anderson : I used your formula and got this-

The Entry no in 4th row (since its the first 'R' item for 'function 2') should be counted as 1 - the end result should have been Function 2. R.001 and not Function 2 R.003. Is there a way to get the desired outcome? Please help!

Please let me know if you guys have any questions. I hope that I have conveyed well this time. Thanks a lot to both of you for doing this!

Regards,

Naveen