+12Hello! 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!
Best answer by Kamille_Parks11
Place an ampersand (and presumably one “space” character) between them.
LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:", ":white_check_mark:")
+27Place an ampersand (and presumably one “space” character) between them.
LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:", ":white_check_mark:")
Place an ampersand (and presumably one “space” character) between them.
LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:", ":white_check_mark:")
Thanks so much! I knew it was something simple like that!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.