Skip to content

Formula (Extended): $CONCAT Function

Overview

Concatenate the specified strings.

Syntax

$CONCAT(Text1,[Text2],...)

Parameters

Parameter Type Required Description
Text1 Arbitrary String Required
[Text2],... Arbitrary String Optional

Column Usable as Parameters

Parameter Classification Numerical Value Date Description Check
Text1 Yes Yes Yes*1 Yes Yes*2
[Text2],... Yes Yes Yes*1 Yes Yes*2

*1: Output the format specified in "Editor Format".
*2: Output the string "True" or "False".

Return Value

Concatenated string.

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, display the options that match the return value
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 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 $CONCAT function in usage example 1

Parameters

Parameters specified in usage example 1 of the $CONCAT function

Calculation Result

Calculation result of usage example 1 of the $CONCAT function

Usage Example ②

Specify four parameters.

Formula

Formula using the $CONCAT function in usage example 2

Parameters

Parameters specified in usage example 2 of the $CONCAT function

Calculation Result

Calculation result of usage example 2 of the $CONCAT function