 # Conditional Character Count Formula

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 , otherwise  If CHANNEL is Facebook and CHARACTER COUNT is between 40 and 80, then , otherwise  If CHANNEL is Instagram and CHARACTER COUNT is between 138 and 150, then , otherwise  If CHANNEL is Linked In and CHARACTER COUNT is between 25 and 140, then , otherwise  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!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.