
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 24, 2021 04:12 PM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 25, 2021 04:38 AM
Erm, shouldn’t that be
LEN({Description}) & " " &
IF(
LEN({Description}) > 310, "red circle",
IF(LEN({Description}) > 260, "other symbol", "green check")
)
?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 24, 2021 05:16 PM
LEN({Description}) & " " &
IF(
LEN({Description}) > 310, "red circle",
IF(
LEN({Description}) > 260, "other symbol",
"green check"
))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 25, 2021 04:38 AM
Erm, shouldn’t that be
LEN({Description}) & " " &
IF(
LEN({Description}) > 310, "red circle",
IF(LEN({Description}) > 260, "other symbol", "green check")
)
?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 25, 2021 05:08 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 25, 2021 05:24 AM
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 ¯_(ツ)_/¯.
