Can you create auto references in a sheet

Amanda O

I have tasks in a sheet and have a column "our reference" can you either put in conditional formatting or create a formula so that you as you add new rows to the sheet it will automatically populate the next number, in the reference column ie

1

2

3

4

5

Andrée Starå

Hi @Amanda O

I hope you're well and safe!

Here's more information on how to add an Auto-Number Column.

https://help.smartsheet.com/articles/1108408-auto-numbering-rows

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Have you looked at the system generated Auto-Number column?

Amanda O

Hi

No I haven't, how do I do that?

Thanks

Andrée Starå

Hi @Amanda O

I hope you're well and safe!

Here's more information on how to add an Auto-Number Column.

https://help.smartsheet.com/articles/1108408-auto-numbering-rows

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Amanda O

Hi Paul

Ignore me, I have worked it out, I didn't know that existed.

Thank you so much

Amanda

Amanda O

Thank you Andree too and have a good weekend

Amanda

Andrée Starå

@Amanda O

Happy to help!