Enclose all text in formulas in double quotes (").
Note: |
Reference numbers, formula names, numeric values, or operators that are enclosed in double quotes are treated as text. |
Following are examples of correctly formatted formulas:
Note: If you are defining a custom query that uses a filter on a string and the string contains a quote ( " ), use a second quote to escape the quote contained in the string.
For example, if you are running a custom query to filter on "Drill Bit 1/4" ", you must escape the quote inside the string. The custom query would be: "Drill Bit 1/4"" ".
See also