Function RELATEDITEMS()

 

Description
Returns a collection of items related to the current item, with optional filtering by direction and identifier type.

Syntax

RELATEDITEMS()

RELATEDITEMS(type)

RELATEDITEMS(type, none, to, from, both)

Parameters

• type – name, externalid, or internalid (defaults to name)
• none – TRUE/FALSE to include relationships with no direction
• to – TRUE/FALSE to include relationships pointing to the item
• from – TRUE/FALSE to include relationships pointing from the item
• both – TRUE/FALSE to include bidirectional relationships

Return Value
ARRAY of TEXT (names, external IDs, or internal IDs)

 

Examples

Formula

RELATEDITEMS()

Result
Returns names of all related items

Formula

RELATEDITEMS("internalid")

Result
Returns internal IDs of all related items

Formula

RELATEDITEMS("name", FALSE, TRUE, FALSE, FALSE)

Result
Returns names of items with relationships pointing to this item

Formula

RELATEDITEMS("externalid", FALSE, FALSE, TRUE, FALSE)

Result
Returns external IDs of items with relationships pointing from this item

Notes

• Defaults to returning names if type not specified
• Useful for roll-ups and filtering with IF/WHERE
• Supports direction-based filtering