Top of PageI get a message saying the results of the formula will be sent to the server
The cell displays the formula instead of the result
I get a message about pending changes when I edit a calculated column
I get a timeout or unanticipated error
I get an error indicating that the list structure has changed
I get an error indicating that I do not have permission to change calculated columns in the list
I cannot edit a formula because one or more other columns require values
I get an error indicating that one or more column references are not allowed
I get an error indicating that a column does not exist
When editing a calculated column, I cannot select the column I want
Cells in a calculated column display #NAME?
Cells in a calculated column display #CIRC!
Cells in a calculated column display #VALUE!
Cells in a calculated column display #NUM!
Cells in a calculated column display #DIV/0!
Cells in a calculated column display #NULL!
Cells in a calculated column display #N/A
You edited the formula, and the list is attempting to submit the new results to the server. Do one of the following:
This could be because of one or more of the following reasons:
Make sure the cell that contains the formula is part of a calculated column. If you enter a formula in a column other than a calculated column, such as a column of type single line of text, the list will treat the formula as a text string and display it as it is.
Any change to a calculated 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.
Refresh the list, and repeat the change you made to the calculated column.
Editing a calculated column results in a change to the list structure. If the list encounters a conflict between the change you made, and a structural change made by another user, you will prompted to refresh the list. Refreshing the list updates your view, but discards the changes you made to the calculated column. Try repeating your change.
Editing a calculated column results in a change to the list structure. If you do not have permissions to make changes to a list structure, you will not be able to edit calculated columns in the list.
The list must commit all of your changes before you can edit a formula. A row cannot be committed if one of its columns is set as a required column, but is left blank. Enter valid values in all the required columns and then trying editing a formula.
The formula includes a reference to a column whose data type does not support calculations. Edit the formula to remove references to unsupported columns.
You have specified a string as an operand, but the list could not find a column with a name that matches the string. Do one or more of the following:
After you type the equal sign (=) in a calculated column, you can paste a column reference simply by clicking the cell in that column that belongs to the current row. However, if the column is of a data type that does not support calculations, or you are attempting to select a cell in a different row or select more than one cell, the list will not paste the column reference in the formula.
A column referenced in a formula does not exist anymore. Either add the column to the list, or edit the formula to remove the reference.
The error is caused by one or more circular references. A circular reference occurs in the following situations:
This error can occur in one of the following two situations:
This error occurs when the formula includes invalid numeric values, such as:
This error occurs when a number is divided by zero (0), such as:
This error occurs when an argument or operand specified in a formula has a null value. If one element of a formula has a null value, the entire formula results in a null value. To avoid this error, make sure null values are replaced with zero (0). You might also want to change the setting of the referenced columns to Required, so that all rows have a non-null value.
This error occurs when a function is missing a value. Make sure you have specified all the required arguments to a function.