Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 14, 2021 01:32 PM
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
Mar 14, 2021 03:24 PM
Do something to the effect of the following:
(
LEN(SUBSTITUTE({type (from Completed task}, ", ", "")) -
LEN(SUBSTITUTE(SUBSTITUTE({type (from Completed task}, ", ", ""), "act", ""))
) / 3
Mar 14, 2021 03:26 PM
Or you could just do a Count field with a condition set to “where type = ‘act’”
Mar 14, 2021 03:49 PM
Yes, that worked perfectly. Thank you :slightly_smiling_face: