Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Character Count Between Two Limits

Topic Labels: Formulas
Solved
Jump to Solution
1055 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nashville_Publi
4 - Data Explorer
4 - Data Explorer

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

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!