Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Conditional formula for character count

Topic Labels: Formulas
Solved
Jump to Solution
519 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Erm, shouldn’t that be

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

?

See Solution in Thread

4 Replies 4
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.

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