Formula to Use to Get the Child Name or Any Value After the Colon Mark

Create a saved search that will extract the child name on a parent child field:

1.    Lists > Search > Saved Searches > New.

2.    Click any Search Type (i.e. Transaction).

3.    Click Results tab > Add Formula (Text) field and add the formula below:

SUBSTR({name},INSTR({name},':')+2)

Note: Change {name} with the correct fieldID where the Parent : Child Name exists.