How can i count this? [solved]

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?

If I use COUNTALL, I just get the total sum of states in this field. How can I just count just “act”?

Tor Martin

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’”

1 Like

Yes, that worked perfectly. Thank you :slight_smile:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.