Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Word Count for Copy Length

Topic Labels: Formulas
Solved
Jump to Solution
1044 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())