
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 16, 2020 04:38 PM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 16, 2020 05:18 PM
You could use a nested IF statement:
IF({Copy}, IF(LEN({Copy})>150,"
:rotating_light: ","
:ok_hand: "), BLANK())

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 16, 2020 05:18 PM
You could use a nested IF statement:
IF({Copy}, IF(LEN({Copy})>150,"
:rotating_light: ","
:ok_hand: "), BLANK())
