Returns the number of characters in a text string, including spaces
Sample Usage
LEN("Hello World!")
Syntax
LEN(
-
text
- text—The string whose length you want returned
Usage Notes
- Formatting (including currency formatting) values aren't counted.
- Dates typically have a length of 8; however, if the date column is being used with dependencies, it has a length of 16.
Examples
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.