Skip to main content

I am trying to auto-number a group of records for one person in a table with multiple people listed with numbers 1,2,3, etc.. In Excel, I would use a formula to add one number to the above cell, and it would number all rows sequentially. I usually manually number each record, but I am hoping a simple formula would number the list.

Here is a screenshot of my table consisting of the records I need based on a filter.  The row with # in the title is where I would put the formula.  Any suggestions?

 

Hi @Wendy_Yelsik ,

Airtable also has an auto-fill feature, though not as powerful as Excel.
This article would be helpful.
https://support.airtable.com/docs/quickly-filling-cells-using-fill-handle

 


Hi @Wendy_Yelsik ,

Airtable also has an auto-fill feature, though not as powerful as Excel.
This article would be helpful.
https://support.airtable.com/docs/quickly-filling-cells-using-fill-handle

 


Well that was super easy!  Thank you for pointing that out.  I was not aware of it.  - Wendy


Reply