Ankit_Srivastav - profile

Ankit_Srivastav · Sep 22, 2021

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 ...

Ankit_Srivastav · Sep 23, 2021

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.

User Statistics

User Activity

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

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