Help

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

Character Count Between Two Limits

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

Hi, I work for a public television station and I’m creating a content database to store records of our productions, improve workflow and communication, etc. We have to submit descriptions for tv listings and the character limits have to fall in the range of 101-250 characters. I’m trying to create a formula that displays the number of characters and let’s the user know if the characters are below 101, between 101-250, or above 250. I find people need the visual warning since I can’t set a X amount of characters or character cut off.

This is the best I can figure out so far, but it’s a little odd:

LEN({Episodic Description}) & IF(LEN({Episodic Description})>250, " Too Long", " Good") & IF(LEN({Episodic Description})<101, " Too Short", " Good")

For example, if some is under the 250 limit the Good pops up. If there isn’t a better formula I can definitely change the tag from " :white_check_mark: Good" to “Over 101” & “Under 250”.

Any ideas? Thanks!

1 Solution

Accepted Solutions

You have to nest your IF statements. delete your first " Good") & and put a closing parentheses at the very end.

See Solution in Thread

2 Replies 2

You have to nest your IF statements. delete your first " Good") & and put a closing parentheses at the very end.

Perfect, thank you so much!