Help

Character Count with symbol

Topic Labels: Formulas
Solved
Jump to Solution
1305 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dennis_Petrou
7 - App Architect
7 - App Architect

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!

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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

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

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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!