Conditional formula for character count

[Dennis_Petrou]

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!

[kuovonne]

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

[Martin_Kopischk · Accepted solution]

Erm, shouldn’t that be

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

?

[kuovonne]

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.

[Martin_Kopischk]

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 ¯_(ツ)_/¯.