Use column formulas to apply calculations to all rows in a sheet

Кроме того, формулы в столбцах позволяют применять одинаковые вычисления и выражения ко всем строкам в таблице. Column formulas will also automatically apply to new rows added anywhere in the sheet. For example, you can: 

• Track the date variance for the planned and actual completion of all project tasks.
• Configure an INDEX function to automatically populate information about an assigned resource, such as their title, department, and supervisor.
• Automatically calculate totals for quote requests based on information submitted through a quote request form.

Создать формулу в столбце

Создать формулу в столбце

1. Write the formula you wish to use in any cell in your desired column.
   
    

   Column formulas cannot refer to cells or ranges with specific row numbers, such as absolute references, specific cell references, or partial-column ranges. Instead, use @row, column references, and cross-sheet references.

   
    

2. After writing the formula, right-click the cell and select Convert to Column Formula from the context menu.

The formula will be applied to all cells in the specified column, and it will be automatically filled into any new rows that are added to the sheet.

You can right-click any cell in the column and select Edit Column Formula or Convert to Cell Formula to change or remove the column formula.

Полный список функций, имеющихся в Smartsheet, см. в статье Список функций. 

Column formula limitations

Only formulas that do not reference specific row numbers can be converted to column formulas. Use the following table as a guide when writing column formulas: