NSC | Saved Search Formula that Indents the results based on Parent-Child heirarchy

Scenario

User needs a Formula for a Saved Search that would the indent the result based on its' parent-child hierarchy.

Solution

In the Results tab of the search, use this formula in a Formula (Text) field:

CASE WHEN (LENGTH({name})-LENGTH(REPLACE({name},':','')))=3 THEN '&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp' || REGEXP_REPLACE({name},'.*: ','  ') WHEN (LENGTH({name})-LENGTH(REPLACE({name},':','')))=2 THEN '&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp' || REGEXP_REPLACE({name},'.*: ','  ') WHEN (LENGTH({name})-LENGTH(REPLACE({name},':','')))=1 THEN '&nbsp&nbsp&nbsp' || REGEXP_REPLACE({name},'.*: ','  ') ELSE REGEXP_REPLACE({name},'.*: ','  ') END