Skip to main content

Hello! I am using LEN({Long Text}) to count the number of characters in a text field. I also see how to use this to display a symbol depending on if its under or over: IF(LEN({Long Text})>280, “ ❌ ”, “ ✅ ”)


How do I combine these in one field? So it would show the character count, and also the symbol for over or under?


Thanks for any help!

Place an ampersand (and presumably one “space” character) between them.


LEN({Long Text}) & " " & IF(LEN({Long Text})>280, "❌", "✅")

Place an ampersand (and presumably one “space” character) between them.


LEN({Long Text}) & " " & IF(LEN({Long Text})>280, "❌", "✅")

Thanks so much! I knew it was something simple like that!

Reply


Terms & Conditions