Skip to main content

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

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

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


Yes, that worked perfectly. Thank you 🙂

Reply


Terms & Conditions