Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Character Count with symbol

Topic Labels: Formulas
Solved
Jump to Solution
1495 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!