Inserting functions in calculated field formulas

You can use functions in calculated field formulas to query item data.

1. Click Insert Function when adding a formula for a calculated field.

The Insert Function dialog box opens.

2. Select the function to add. See Calculated custom field functions.

Select a function category from the Category list to display the function type you want. You can also enter the first few letters of the function name in the Filter field to display matching functions.

3. Enter the function Inputs.

The last line of a formula must evaluate to the same value type as the selected output. Each function lists the value type it returns in the Output area.

4. Click Insert.

The function is inserted in the formula.