# How to get total items in a column
**URL:** https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853
**Category:** Questions about Thunkable X
**Tags:** spreadsheets
**Created:** [July 20, 2022, 6:37pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853 "2022-07-20T18:37:24Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 20, 2022, 6:37pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/1 "2022-07-20T18:37:24Z")
Am wandering if there is a way to calculate and get the total number of items entered in a column in Airtable Spreadsheet?
Just like getting a total number of object created in a column.
Thanks for your support
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [July 21, 2022, 5:08am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/2 "2022-07-21T05:08:57Z")
have you tried this (untested)?
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 21, 2022, 5:31am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/3 "2022-07-21T05:31:12Z")
Thank you I will try it out
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [July 21, 2022, 10:24am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/4 "2022-07-21T10:24:30Z")
If the `column values` are retrieved as **numbers** then the blocks of @manyone will work. If in the other hand, the values are being retrieved as **text** , these blocks will not solve the issue.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [July 21, 2022, 2:03pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/5 "2022-07-21T14:03:54Z")
What exactly are you wanting to count? Is it the number of rows? If not, can you give an example of what the data looks like and the value you would expect that data to have for the “total items” in that column?
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 21, 2022, 2:59pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/6 "2022-07-21T14:59:51Z")
I want users to know the total number of items that they save to the spreadsheet…
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [July 21, 2022, 3:29pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/7 "2022-07-21T15:29:36Z")
Would this block suit your needs?
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 21, 2022, 3:44pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/8 "2022-07-21T15:44:59Z")
I would try it ,not on my laptop yet
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [July 22, 2022, 12:45am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/9 "2022-07-22T00:45:37Z")
> [@versatile](#):
>
> I want users to know the total number of items that they save to the spreadsheet…
I still don’t know what that means. What is an “item” in a spreadsheet?
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 22, 2022, 1:19am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/10 "2022-07-22T01:19:30Z")
What I meant by items are whatever they may have stored into the spreadsheet by creating objects from the Thunkable blocking.Images stored and any other text entered .
This is like a Diary or lemme say Journal App
---
### Author:  [@zander](https://community.thunkable.com/u/zander)
#### Post date: [July 22, 2022, 1:30am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/11 "2022-07-22T01:30:09Z")
You’re asking for like “number of rows” in the data source right? If so thus should help:
Also link to the documentation: [https://docs.thunkable.com/v/drag-and-drop/data-sources](https://docs.thunkable.com/v/drag-and-drop/data-sources)
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 22, 2022, 2:44am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/12 "2022-07-22T02:44:10Z")
Thanks
---
### Author:  [@zander](https://community.thunkable.com/u/zander)
#### Post date: [July 22, 2022, 4:04am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/13 "2022-07-22T04:04:05Z")
If I answered your question please click “Solution” on my post, so that the answer appears at the top to help others out 😆
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 27, 2022, 2:10am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/14 "2022-07-27T02:10:44Z")
Am using the stp version of the Thunkable
---
### Author:  [@zander](https://community.thunkable.com/u/zander)
#### Post date: [July 27, 2022, 2:24am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/15 "2022-07-27T02:24:09Z")
That block is also there in stp
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 27, 2022, 2:36am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/16 "2022-07-27T02:36:00Z")
Can’t find it yet,or I rather do that through the data source feature
Thanks
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 27, 2022, 2:40am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/17 "2022-07-27T02:40:54Z")
Can I get total value of a columns from more than one base in spreadsheet and output in a single label?
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 27, 2022, 2:48am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/18 "2022-07-27T02:48:39Z")
Yea , you’re right,it only returns as text
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 27, 2022, 3:04am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/19 "2022-07-27T03:04:36Z")
Still can’t find it
---
### Author:  [@zander](https://community.thunkable.com/u/zander)
#### Post date: [July 27, 2022, 3:09am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/20 "2022-07-27T03:09:41Z")
If you link your project we might be able to help better. It’s hard to see what you’re seeing.
[Next page](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853.md?page=2)