True[TRUE] False[FALSE]

Returns TRUE or FALSE in a function where the argument requires True or False data.

Example

The Join Strings [TEXTJOIN] function has the option to ignore empty fields.

TEXTJOIN (“Delimiter”, IgnoreIfEmpty, “Text1”, “Text2”, ...)

In the following TEXTJOIN expression, we insert TRUE for the IgnoreIfEmpty argument, which is a True/False data type.

Expression

TEXTJOIN (“, ”, TRUE, Renovation Status, Related Zone Name)

The expression will therefore ignore empty fields.

See Join Strings [TEXTJOIN] for an example.