Skip to main content

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, “ ⭕ ”, “ ✅ ”)


Thanks!

LEN({Description}) & " " & 

IF(

  LEN({Description}) > 310, "red circle", 

IF(

  LEN({Description}) > 260, "other symbol",

  "green check"

))




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")

)

?

Erm, shouldn’t that be


LEN({Description}) & " " & 

IF(

  LEN({Description}) > 310, "red circle", 

  IF(LEN({Description}) > 260, "other symbol",  "green check")

)

?


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.

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.


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

Reply


Terms & Conditions