| author | spgraph-docs-team |
|---|---|
| title | calculatedColumn resource type |
| ms.localizationpriority | medium |
| description | The calculated column on a columnDefinition resource indicates that the column's data is calculated based on other columns in the site. |
| ms.subservice | sharepoint |
| doc_type | resourcePageType |
| ms.date | 07/22/2024 |
Namespace: microsoft.graph
The calculatedColumn on a columnDefinition resource indicates that the data of the column is calculated based on other columns in the site.
| Property | Type | Description |
|---|---|---|
| format | String | For dateTime output types, the format of the value. The possible values are: 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. The possible values are: boolean, currency, dateTime, number, or text. |
SharePoint formulas use a syntax similar to Excel formulas. For more information, see Examples of common formulas in SharePoint Lists.
The following JSON representation shows the resource type.
{
"format": "String",
"formula": "String",
"outputType": "String"
}