Add or edit a calculated column in Datasheet view
You can add a column that calculates values for each row based on other values in the same row.
Add a calculated column- Right-click a column header, and click Add Column.
- On the Add Column page, specify a name for the column.
- Select Calculated as the type of information that will be stored in the column.
- In the Formula text area, type a new formula. To insert column references, select a column in the Insert Column list, and click Add to formula.
- Specify the format of the value that will be returned by the formula, and other related settings.
- Right-click the column, and click Edit/Delete Column.
- In the Formula text area, edit the existing formula. To insert column references, select a column in the Insert Column list, and click Add to formula.
- Specify the format of the value that will be returned by the formula, and other related settings.
Notes
- Adding or editing a column results in a change to the list structure. You can make a structural change to a list, only if there are no pending changes, conflicts, and errors. If the list encounters one of these in the list, you will prompted to wait until all changes are submitted to the server, and resolve any conflicts and errors, before you can add or edit a column.
- You cannot change the data type of a column to Calculated. To use a formula in a non-calculated column, you must delete the column and then add a calculated column.