Converts any uppercase characters to lowercase
Syntax
LOWER(text)
- text—The text to convert
Sample usage
LOWER("HELLO WORLD!")
Examples
Formula | Description | Result |
---|---|---|
Formula LOWER("JANE DOE") | Description Converts the name "JANE DOE" from uppercase to lowercase. | Result "jane doe" |
Formula LOWER("EMAIL@EXAMPLE.COM") | Description Converts the email address "EMAIL@EXAMPLE.COM" to all lowercase. | Result "email@example.com" |
Formula LOWER("IMPORTANT NOTICE: MEETING AT NOON") | Description Converts the title to lowercase for a uniform appearance. | Result "important notice: meeting at noon" |
Formula LOWER("PRODUCT CODE: XYZ123") | Description Converts the product code to lowercase for database uniformity. | Result "product code: xyz123" |
Still need help?
Use the Formula Handbook template to find more support, resources, and view 100+ formulas. It includes a glossary of every function that you can practice working with in real-time and examples of commonly used and advanced formulas.
In the Smartsheet online community, you can find examples of how other Smartsheet customers use this function or ask about your specific use case.