Help

How you can create a column for counting number of entries in each cell of a column? Is there a formula for that?

Solved
Jump to Solution
1757 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankit_Srivastav
4 - Data Explorer
4 - Data Explorer

I am trying to count the number of values entered in each cell of a column, just so that I can perform certain automation. like for example, if the column name is 'Colleagues" and the first row in this column contains three names of colleagues. Then how can I automatically detect that there are 3 names/values entered in this cell?

1 Solution

Accepted Solutions

I have got the answer,
I tried out this one for counting number of entries(and yes it was linked using lookup for colleagues) ::
IF(
LEN({Colleagues})=0,0,
LEN({Colleagues})-LEN(SUBSTITUTE({
Colleagues},",",""))+1)

Thanks for the reply.

See Solution in Thread

2 Replies 2

Hi @Ankit_Srivastava ,

Welcome to Airtable community!

Do the values in the cell come from a "linked to " field? If yes you can create a new field with the type of “count” and this counts the values which are in the field.

If it doesn’t work please don’t hesitate to post back again :slightly_smiling_face:

Thanks

I have got the answer,
I tried out this one for counting number of entries(and yes it was linked using lookup for colleagues) ::
IF(
LEN({Colleagues})=0,0,
LEN({Colleagues})-LEN(SUBSTITUTE({
Colleagues},",",""))+1)

Thanks for the reply.