Skip to content
ProcessPlanProcessPlan Docs

=LISTMERGE

The =LISTMERGE() function accepts two semicolon separated text lists and returns a list containing all the unique entries from both lists.

Syntax

Section titled “Syntax”
=LISTMERGE(SemicolonSeparatedList1; SemicolonSeparatedList2)

Parameters

Section titled “Parameters”

  • SemicolonSeparatedList1 – The first semicolon-separated list of text values.

  • SemicolonSeparatedList2 – The second semicolon-separated list of text values.

How It Works

Section titled “How It Works”

  • Combines both lists into a single list.

  • Removes duplicate entries, so each value appears only once.

  • Returns the resulting list in the order of first occurrence.

Usage Notes

Section titled “Usage Notes”
  • Formula functions are case sensitive and must be written in ALL CAPS.

Example

Section titled “Example”

If the List A field contains:

Entry1; Entry2; Entry3

and the List B field contains:

Entry2; Entry3; Entry4

then:

=LISTMERGE([[Field: List A (Text)]]; [[Field: List B (Text)]])

Returns

Entry1; Entry2; Entry3; Entry4

Keywords

Section titled “Keywords”

LISTMERGE, merge lists, unique entries, remove duplicates, semicolon-separated list, list processing, workflow formulas, formula function