Syntax
LEN(text)
- text—The string whose length you want returned
Sample usage
LEN("Hello World!")
Usage notes
The LEN function doesn’t count formatting values (including currency formatting).
- Dates typically have a length of 8 values; however, if the date column has dependencies, it has a length of 16 values.
Examples
Use =LEN(column@row) as the base of your LEN functions.
To ensure you have the correct syntax for the column name, type =LEN( and then select the column you want to use.
Example 1 - Identify the length of comment values
=IF(LEN(Comments@row)>30, 1, 0)
This LEN formula calculates the number of characters in the text of the Comments Primary column for the row for the formula. Use this option to filter for detailed comments or rows with no comments.
Example 2 - Add leading 0’s (zeroes) and standardize the length of an ID value always to be at least three digits long
=IF(LEN([ID Value]@row)=2, “0”+[ID Value]@row, IF(LEN([ID Value]@row)=1, “00”+[ID Value]@row), [ID Value]@row)
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.