How to: Create a Formula Field for a Folder

  1. In the Navigation Pane, select the folder for which you want to create the formula field.

  2. On the View tab, in the Current View group, click View Settings.

  3. In the Advanced View Settings: <view> dialog box, click Columns.

  4. In the Show Columns dialog box, click New Column.

  5. In the Name box, type a name for the column.

  6. In the Type box, click Formula.

  7. Click Edit.

  8. To insert a function in the formula, click Function, point to the function set that you want, and then click the formula that you want.

  9. To insert a field in the formula, select the argument that you want to replace, click Field, point to the field set that you want, and then click the field that you want.

  10. Click OK twice.

  11. To position the field between the other fields in the view, click the field, and then click Move Up or Move Down.

  12. To remove the field from the view, click Remove.

Note

  • Formula fields are updated with any change to a view. For example, if you change the width of a column, the formula fields are updated.

  • You cannot sort, group, or filter the contents of a formula field.