Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Count unique emojis ✔

Topic Labels: Formulas
797 1
Showing results for 
Search instead for 
Did you mean: 

Hi! I am trying to do a COUNTIF type formula but I cannot find anything to work. Not sure why I cannot upload images or links to this post.

Basically, I have a lookup column that looks up info from another table and shows an array with emojis (checkmark, x, triangle); so, for example, the first cell shows :heavy_check_mark: , :heavy_check_mark: , :heavy_check_mark: , :x: , :heavy_check_mark: , :heavy_check_mark: . I want the second column to count how many green checkmarks are in the first column; that is, I want it to show the number 5. Any ideas?

1 Reply 1

Hi @Polly_Daugherty

You could try getting the length of the whole thing as a string before and after removing that emoji from the string, and then get the difference.

So you’d do something like:

LEN({Your Lookup Field}&"") -
LEN(SUBSTITUTE({Your Lookup Field}&"", "✔️",  ""))