Formula Syntax Examples

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

Data Limitations

Formula Editor