Help

Count instances of String

Topic Labels: Formulas
Solved
Jump to Solution
1813 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Use a conditional COUNT field instead.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Use a conditional COUNT field instead.

Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

@ScottWorld you nailed it. Thanks!