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