Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Conditional Character Count Formula

Topic Labels: Formulas
Solved
Jump to Solution
412 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I had a functional formula formerly from a template, and then I went and copied tables between bases, and lost the actual formula in the field. What I’m trying to recreate is a conditional formula that returns a status on character count based on the social channel selected in another field. Basically:

If CHANNEL is Twitter and CHARACTER COUNT is between 71 and 100, then :ok_hand: , otherwise :exclamation: :exclamation:
If CHANNEL is Facebook and CHARACTER COUNT is between 40 and 80, then :ok_hand: , otherwise :exclamation: :exclamation:
If CHANNEL is Instagram and CHARACTER COUNT is between 138 and 150, then :ok_hand: , otherwise :exclamation: :exclamation:
If CHANNEL is Linked In and CHARACTER COUNT is between 25 and 140, then :ok_hand: , otherwise :exclamation: :exclamation:

Thanks in advance!

1 Solution

Accepted Solutions

Hi @Nicole_Flewellen

This should work (copy paste in formula field):

IF(AND(channel="Twitter",LEN(Text)>=71,LEN(Text)<=100),"ok",IF(AND(channel="Facebook",LEN(Text)>=40,LEN(Text)<=80),"ok",IF(AND(channel="Instagram",LEN(Text)>=138,LEN(Text)<=150),"ok",IF(AND(channel="Linkedin",LEN(Text)>=25,LEN(Text)<=40),"ok","nok"))))

“channel” = single select field with social channel
“Text” = single line text field with your message
Replace “ok” and “nok” with your symbols

Let me know if this works!

See Solution in Thread

2 Replies 2

Hi @Nicole_Flewellen

This should work (copy paste in formula field):

IF(AND(channel="Twitter",LEN(Text)>=71,LEN(Text)<=100),"ok",IF(AND(channel="Facebook",LEN(Text)>=40,LEN(Text)<=80),"ok",IF(AND(channel="Instagram",LEN(Text)>=138,LEN(Text)<=150),"ok",IF(AND(channel="Linkedin",LEN(Text)>=25,LEN(Text)<=40),"ok","nok"))))

“channel” = single select field with social channel
“Text” = single line text field with your message
Replace “ok” and “nok” with your symbols

Let me know if this works!

Works like a charm! Thank you!