What saved search formula can be used to pull out the child value when the record name displays as Parent : Child when using the standard Name field?

AI generated answer (using internal Slack threads):

To pull out the child value when the record name displays as Parent : Child when using the standard Name field, you can use the SUBSTR and INSTR functions in a formula. Here is an example of how you can do this:

Formula (text)
SUBSTR({name}, INSTR({name}, “:”) + 2)

This formula will display the characters of the name field from the point where the colon (":") is found. The "+2" is used to start from the character after the colon and the space that follows it. Please note that this formula assumes that there is a space after the colon. If there is no space after the colon in your data, you should use "+1" instead of "+2". ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******