Character Count with symbol

[Dennis_Petrou]

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, “ :x: ”, “ :white_check_mark: ”)

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!

[Kamille_Parks · Accepted solution]

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

LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:", ":white_check_mark:")

[Dennis_Petrou]

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