Converts any uppercase characters to lowercase
Syntax
LOWER(text)
- text—The text to convert
Sample usage
LOWER("HELLO WORLD!")
Examples
| Formula | Description | Result |
|---|---|---|
| LOWER("JANE DOE") | Converts the name "JANE DOE" from uppercase to lowercase. | "jane doe" |
| LOWER("EMAIL@EXAMPLE.COM") | Converts the email address "EMAIL@EXAMPLE.COM" to all lowercase. | "email@example.com" |
| LOWER("IMPORTANT NOTICE: MEETING AT NOON") | Converts the title to lowercase for a uniform appearance. | "important notice: meeting at noon" |
| LOWER("PRODUCT CODE: XYZ123") | Converts the product code to lowercase for database uniformity. | "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.