LEN Function

Returns the number of characters in a text string, including spaces
Sample Usage
LEN("Hello World!")
  • 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.

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.

Ask the Community