Content Comparison

For example, in a Project object with related Task Owner records, you can use the Concat rollup type to list all "Tasks" in a single field on the Project. After the rollup calculation, it will return all task names in the selected destination field on the Project object, using the specified delimiters and qualifiers.

The object hierarchy might look like this:

Tasks Task → Task Owners → Project

Field to Rollup: Task Description
Delimiter: Comma (,)
Qualifier: Double Quotes(“ ")

• Project A:

  • Mark Antony : "Design mockup"

  • Natasha Hedgehog : "Develop feature"

  • Ryan Ten : "Review code"

Result: "Design mockup, Develop feature, Review code"