
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 20, 2021 09:14 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 20, 2021 09:21 AM
Place an ampersand (and presumably one “space” character) between them.
LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:", ":white_check_mark:")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 20, 2021 09:21 AM
Place an ampersand (and presumably one “space” character) between them.
LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:", ":white_check_mark:")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 20, 2021 09:24 AM
Thanks so much! I knew it was something simple like that!
