Sep 21, 2020 12:58 PM
I have a rollup field that uses ARRAYJOIN() to produce string values separated by commas. Next, I want to be able to count all instances of a particular string.For Example, the field I want to count contains: BT,DT,BT, DT. I want to count only the “DT.” Any suggestions on what formulas are able to do this? I would use a conditional rollup, but it doesn’t feature any “IF” statements.
Solved! Go to Solution.
Sep 21, 2020 01:01 PM
Sep 21, 2020 01:01 PM
Use a conditional COUNT field instead.
Sep 21, 2020 01:07 PM
@ScottWorld you nailed it. Thanks!