Help

Word Count for Copy Length

Topic Labels: Formulas
Solved
Jump to Solution
965 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Natalie_Elliott
4 - Data Explorer
4 - Data Explorer

Hi,

I’m having trouble with the following formula: IF(LEN({Copy})>150,“ :rotating_light: ”,“ :ok_hand: ”). It returns “ :rotating_light: ” if the Copy cell quantity is longer than 150 characters and “ :ok_hand: ” if less than 150. However, I’d like it to return a blank value if the Copy cell is empty. I’ve tried adding “BLANK ()” to the formula a few different ways, but it either returns an error message or doesn’t take. Any help would be appreciated. Thank you!

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

You could use a nested IF statement:

IF({Copy}, IF(LEN({Copy})>150," :rotating_light: "," :ok_hand: "), BLANK())

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

You could use a nested IF statement:

IF({Copy}, IF(LEN({Copy})>150," :rotating_light: "," :ok_hand: "), BLANK())