Formula To Get Item Child Name Only in a Saved Search

Use the below formula to return only the item’s child name in a saved search.

Formula(Text): REGEXP_REPLACE(REGEXP_SUBSTR({name},’: [^:]+*$’),’: ‘,”)

For example without the formula a parent: child item will display as:

Parent Item Name: Child Item Name

Using the formula only the Child Item Name will display.

Leave a comment

Your email address will not be published. Required fields are marked *