Help

How to simply add a column of numbers in Airtable?

Topic Labels: Formulas
1184 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Amy1
4 - Data Explorer
4 - Data Explorer

How do I add a column of numbers quickly without creating a formula?

5 Replies 5

Assuming you're looking for an automatic sequential column of:
1
2
3
etc

You could try the autonumber field: https://support.airtable.com/docs/number-based-fields-in-airtable#autonumber-fields

That page has a bunch of info on other number based fields too!

ScottWorld
18 - Pluto
18 - Pluto

Hi @Amy1,

There is a summary bar at the top and/or bottom of each column. (The location depends on if you have grouping turned on or off.)

Just click on the summary bar and choose SUM.

For more Airtable tips & tricks like this, you may want to check out my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning.

I discuss the summary bar in my course.

p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

Amy1
4 - Data Explorer
4 - Data Explorer

Thanks @ScottWorld but how do I see the summary bar? I can't see one at all....

 

You will need to be in a grid view, and then hover your mouse at the bottom of the column (or at the top of a group).