Count Specific Characters or Strings in Text String
Cowboy Rick Fogerty
Please add a new native formula function to the SmartSuite custom calculation engine that allows users to count how many times a specific character or sequence of characters (substring) appears within a text string.
For example, how many times does "i" appear in "Mississippi", or how many times does "ss" appear in "Mississippi"?
Proposed solution:
Syntax: OCCURRENCES([Text Field], "Search Target")
Examples:
- Single Character Search: OCCURRENCES("Mississippi", "i")
Expected Output: 4
- Multiple Character (Substring) Search: OCCURRENCES("Mississippi", "ss")
Expected Output: 2
Business Use Cases:
Implementing this function would dramatically expand the range of custom computations available to Solution Managers across several operational workflows.