📌 More functions: see the Formula function reference.

1 Basics

TEXTJOIN joins multiple text strings into one. Unlike simple concatenation, TEXTJOIN lets you set a delimiter and optionally skip empty cells.

Syntax

TEXTJOIN([delimiter], [ignore_empty], [text1], [text2])

delimiter: a string or a reference to a valid string — may be empty. If empty, texts are concatenated directly. ignore_empty: a boolean. If TRUE, empty cells in the text args are skipped. text1: any text — a string or an array of strings from a range. text2: more text.

Examples

Single record (row): Field 1 = “Apple”, Field 2 = “Banana”, Field 3 = empty, Field 4 = “Grape”.

Example 1: skip empty

TEXTJOIN(", ", TRUE(), [Field 1], [Field 2], [Field 3], [Field 4])

Result: Apple, Banana, Grape

Example 2: keep empty

TEXTJOIN(", ", FALSE(), [Field 1], [Field 2], [Field 3], [Field 4])

Result: Apple, Banana, , Grape With TEXTJOIN, combine info from multiple sources into a readable, processable string — control delimiter and empty handling.

2 Scenario examples

2.1 Combine fields

Combine store [Name] and [Status] with ”-“.

TEXTJOIN("-",TRUE(),[Name],[Status])

2.2 Combine multi-select options

Combine multi-select field [Feedback type (AI tag)] with ”+”.

TEXTJOIN("+",TRUE(),[Feedback type (AI tag)])

Using TEXT Function practices

​1 Basics

​Syntax

​Examples

​Example 1: skip empty

​Example 2: keep empty

​2 Scenario examples

​2.1 Combine fields

​2.2 Combine multi-select options