How can i count this? [solved] | Airtable Community

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

Regards,
Tor Martin

Page 1 / 1

Do something to the effect of the following:

(
   LEN(SUBSTITUTE({type (from Completed task}, ", ", "")) - 
   LEN(SUBSTITUTE(SUBSTITUTE({type (from Completed task}, ", ", ""), "act", ""))
) / 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:

Sign up