Skip to main content
Solved

Count instances of String

  • September 21, 2020
  • 2 replies
  • 0 views

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.

Best answer by ScottWorld

Use a conditional COUNT field instead.

View original
Did this topic help you find an answer to your question?

2 replies

ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8721 replies
  • Answer
  • September 21, 2020

Use a conditional COUNT field instead.


@ScottWorld you nailed it. Thanks!


Reply