Using Formula Expression CONCAT to Join 2 Fields and Character “&” in Between Gives Error Invalid Expression in Saved Search

Scenario

When users use CONCAT to join multiple fields, the expression as below is used:

Concat({fieldidAAA}, concat(concat(‘ ‘, {fieldidBBB}), concat(‘ ‘, {fieldidCCC})))

However, when the said expression is used to join a character, it gives an Invalid Expression. Sample formula that shows this problem:

Concat({fieldidAAA}, concat(concat(‘ ‘, ‘&’}), concat(‘ ‘, {fieldidBBB})))

Solution

Sample formula that shows this problem:

1. Navigate to Lists > Search > Saved Searches
3. Search Type: Click Case
5. Search Title: Enter Title
7. Click Results
9. Click Columns
11. Field:

 Formula text {fieldidAAA} || ‘&’ || {fieldidBBB}

○ Click Add

1. Click Save & Run