# Conditional formula for character count

Topic Labels: Formulas
Solved
2128 4
cancel
Showing results for
Did you mean:
7 - App Architect

Hello, I am using this formula to display a red circle if a character count is over 310, or a green check if its not. I would like to add another condition but cannot get the syntax right, any help? I would like to add a 3rd condition, so if it is over 260 but under 310 it has a third symbol…

LEN({Description}) & " " & IF(LEN({Description})>310, “ :o: ”, “ :white_check_mark: ”)

Thanks!

1 Solution

Accepted Solutions
7 - App Architect

Erm, shouldn’t that be

``````LEN({Description}) & " " &
IF(
LEN({Description}) > 310, "red circle",
IF(LEN({Description}) > 260, "other symbol",  "green check")
)
``````

?

4 Replies 4
18 - Pluto
``````LEN({Description}) & " " &
IF(
LEN({Description}) > 310, "red circle",
IF(
LEN({Description}) > 260, "other symbol",
"green check"
))

``````
7 - App Architect

Erm, shouldn’t that be

``````LEN({Description}) & " " &
IF(
LEN({Description}) > 310, "red circle",
IF(LEN({Description}) > 260, "other symbol",  "green check")
)
``````

?

18 - Pluto

Yes! Thank you for the catch!

I was typing on my phone and obviously wasn’t paying close enough attention. Not an excuse, but an explanation.

7 - App Architect

Ha, no worries. Actually, seeing how you are usually far better informed than me about API and feature changes, I had hoped Airtable quietly added `else if` clauses to `IF()`. No such luck, I guess ¯_(ツ)_/¯.