編輯

共用方式為

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.