calculatedColumn resource type
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.
Properties
| Property | Type | Description |
|---|---|---|
| format | String | For dateTime output types, the format of the value. 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. 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.
JSON representation
The following JSON representation shows the resource type.
{
"format": "String",
"formula": "String",
"outputType": "String"
}