# How to count items in Split Text column? **URL:** \ **Category:** Ask for Help\ **Created:** [May 18, 2021, 12:17am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899 "2021-05-18T00:17:18Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![willem](https://avatars.discourse-cdn.com/v4/letter/w/898d66/32.png) [@willem](https://community.glideapps.com/u/willem)\ **Post date:** [May 18, 2021, 12:17am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/1 "2021-05-18T00:17:18Z")
Hi! How can I calculate the number of items in a Split Text column? Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 18, 2021, 12:41am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/2 "2021-05-18T00:41:44Z")
Unless you have a relation on top of that and can use a rollup column, you can’t count it. ---
**Author:** ![willem](https://avatars.discourse-cdn.com/v4/letter/w/898d66/32.png) [@willem](https://community.glideapps.com/u/willem)\ **Post date:** [May 18, 2021, 12:44am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/3 "2021-05-18T00:44:50Z")
How could I go about putting it in a relationship if it’s inside the same table? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 18, 2021, 12:45am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/4 "2021-05-18T00:45:47Z")
Can you explain in more details what you are trying to do and what is your setup here? You can still create relations within the same table, to be clear. ---
**Author:** ![willem](https://avatars.discourse-cdn.com/v4/letter/w/898d66/32.png) [@willem](https://community.glideapps.com/u/willem)\ **Post date:** [May 18, 2021, 12:48am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/5 "2021-05-18T00:48:27Z")
I have multiple image columns for the purpose of creating a carousel. Each column is sequential “Image 1”, “Image 2”, etc. The user has the option to upload a max of six images for a post. I want to create a column that counts the number of images in that carousel, which technically is a Split Text column. Hope this makes sense. Thank you! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 18, 2021, 12:55am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/6 "2021-05-18T00:55:25Z")
So I assume this is a Glide table and you have 6 separate image columns joined into a template and then split into an array with a Split Text column? Probably not the cleanest solution, but you may want to create 6 IF columns that check each image column. If it’s empty, then return 1, else return 0. Then create a math column that adds up all the numbers from the IF columns. ---
**Author:** ![willem](https://avatars.discourse-cdn.com/v4/letter/w/898d66/32.png) [@willem](https://community.glideapps.com/u/willem)\ **Post date:** [May 18, 2021, 12:56am UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/7 "2021-05-18T00:56:14Z")
This will do the trick 😃 thank you! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/how-to-count-items-in-split-text-column/26899/8 "2024-01-17T16:52:09Z")