Formula (Text) Value which starts with the Word ‘User’ Returns “ERROR: Invalid Expression” in the Search Results

When using a Formula (Text) to return a value that starts with "User", the search result returns "ERROR: Invalid Expression".


Using the simple steps below, we can demonstrate how the error happens to better understand this unique scenario:


1. Go to Lists > Search > Saved Searches > New > Transaction.
2. Under the Results tab > Columns sub tab, add:
   • Formula (Text) 
     - Type this value in the Formula field: 'user' 
4. Preview. "ERROR: Invalid Expression" appears in the Search Results.


This errors because the word "User" is a reserved word and is not recognized as a string in the system.  


To avoid this error concatenate the characters to form the word "User". Like: 


   • CONCAT('Use', 'r') 
      Or
   • 'Use' || 'r'