Formula (Extended): $TRIM Function

Dec 6, 2023Jun 7, 2024

Overview¶

Remove unnecessary spaces before and after a string. Spaces within the string are not removed.

$TRIM(string)

Parameter	Type	Required	Description
String	Arbitrary String	Required

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

A string with spaces before and after the string removed.

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