Skip to content

Formula (Advanced): $LOWER Function

Overview

Convert uppercase English characters in a string to lowercase English characters.

Syntax

$LOWER(String)

Parameters

Parameter Type Required Description
String Arbitrary String Required

Column Usable as Parameters

Parameter Classification Numerical Value Date Description Check
String Yes Yes Yes Yes No

Return Value

A string with uppercase English characters converted to lowercase English characters.

Return Value Display Content

Target Display Content of Return Value
Classification (including title, status, manager, owner) Display return value. If the return value is a half-width numerical value and is a drop-down list with values, the options that match the value are displayed.
Numerical Value (including work volume, progression rate, remaining work volume) Display return value only if the return value is a half-width numerical value.
Date (including start and completion) Display return value only if the return value is a string in date format.
Description (including content) Display return value.
Check (including lock) Do not display.

Usage Example ①

Specify parameters by screen column name (name displayed)

Formula

Formula using the $LOWER function in usage example 1

Parameters

Parameters specified in usage example 1 of the $LOWER function

Calculation Result

Calculation result of usage example 1 of the $LOWER function