Count specific items. (ie. count items in rollup/multi-select property called High Impact)
Extract 1st, 2nd, 3rd, 4th, 5th ... last, ect. items in a list.
Analytics
Formulas
Return How Many Times Item Occurs
aka. find number of tags that say "matched character." Replace "Low Impact" with phrase you want to match.
length(replaceAll(replaceAll(prop("Impact"), "Low Impact", "§"), "[^§]", ""))
Extract Item From List String
aka. extract the 1st, 2nd, 3rd, 4th, etc. item from a list. This can be from a multi-select property, a rollup like above, or even a list separated by commas.
Is your list separated by characters that aren't commas? Switch anywhere you see a comma with your special character.
- 0 = first item
- 1 = second item
- 2 = third item
- Extract Item From List String (Rollup of multi-select property)
replaceAll(replace(prop("Impact"), "(?:[^,]*,){2}", ""), ",.*", "")
- Extract Item From List String (Multi-Select or Text with extra space between items)
replaceAll(replace(prop("Impact"), "(?:[^,]*, ){2}", ""), ",.*", "")