formula to show parent project and child project in two separate columns in transaction saved search

AI generated answer (using internal Slack threads):

To show the parent project and child project in two separate columns in a transaction saved search, you can use the following approach: 1. For the Parent Project, you can use the field

Main Line Name

with a join to

Sub Of

. This will give you the parent project name. 2. For the Child Project, you can use the field

Customer/Project (Main)

. This will give you the child project name. If you are unable to find these fields directly, you can use a formula field to extract the required information. For example, you can use a formula like

TRIM(REGEXP_SUBSTR({accountgrouped}, '[^:]+'))

to extract the parent account string. Please note that the exact field names and formula may vary depending on your specific NetSuite setup and the structure of your data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

not working