Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How can i count this? [solved]

1177 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tor_Martin_Norv
6 - Interface Innovator
6 - Interface Innovator

I have a lookup field giving me three different states: “act”, “belong” and “commit”
How can I count how many times “act” is in this lookup field?

Skjermbilde 2021-03-14 kl. 21.30.51

If I use COUNTALL, I just get the total sum of states in this field. How can I just count just “act”?
Skjermbilde 2021-03-14 kl. 21.31.16

Regards,
Tor Martin

3 Replies 3

Do something to the effect of the following:

(
   LEN(SUBSTITUTE({type (from Completed task}, ", ", "")) - 
   LEN(SUBSTITUTE(SUBSTITUTE({type (from Completed task}, ", ", ""), "act", ""))
) / 3

Or you could just do a Count field with a condition set to “where type = ‘act’”

Yes, that worked perfectly. Thank you :slightly_smiling_face: