Conditional formula for character count

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!

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

Erm, shouldn’t that be

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

?

1 Like

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.

1 Like

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

1 Like

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