Word Count for Copy Length


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!

You could use a nested IF statement:

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

1 Like

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