Add or edit a calculated column in Datasheet view

Microsoft Datasheet View

Show All Show All

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.

ShowAdd a calculated column

ShowEdit a calculated column

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.