CalculatedColumn resource type
The calculatedColumn on a columnDefinition resource indicates that the column's data is calculated based on other columns in the site.
JSON representation
Here is a JSON representation of a calculatedColumn resource.
{
"format": "dateOnly | dateTime",
"formula": "=[Column1]+[Column2]+[Column3]",
"outputType": "boolean | currency | dateTime | number | text",
}
Properties
Property name | Type | Description |
---|---|---|
format | string | For dateTime output types, the format of the value. Must be one of dateOnly or dateTime . |
formula | string | The formula used to compute the value for this column. |
outputType | string | The output type used to format values in this column. Must be one of boolean , currency , dateTime , number , or text . |
SharePoint formulas use a syntax similar to Excel formulas. See Examples of common formulas in SharePoint Lists for more information.