NSC | How To Split The Alphanumeric Department Name on Departments List?

Scenario: User has Alphanumeric Department Names and would like to split the number and name on the Departments List.

To achiever this we may create a Department Saved Search that we can use as the List View.

Here are the steps we may take:

1. Go to Transactions > Management > Saved Search > New

2. Click on Department

3. Add Search Title

4. Mark the Available as List View checkbox

5. Under Results tab, add the following:

• Name (no hierarchy)
• Formula (Text) = SUBSTR({namenohierarchy},1,6)
• Name

6. Click Save & Run

7. Go to Setup > Company > Departments

8. On the VIEW, change the Department Default View into the Saved Search recently created