Learning Track
This Help Article appears in the Smartsheet Intermediate learning track. Get the most out of this learning track by starting at the beginning.
This Help Article appears in the Smartsheet Intermediate learning track. Get the most out of this learning track by starting at the beginning.
This Help Article appears in the Get Started learning track. Get the most out of this learning track by starting at the beginning.
The Owner and Admins can set, edit, and remove column formulas. A license is required.
Individual, Business, Enterprise, and Premier
With column formulas, you can apply uniform calculations and expressions to all rows in the sheet. Column formulas will also automatically apply to new rows added anywhere in the sheet. For example, you can:
To create a column formula:
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.
Column formula limitations
Only formulas which do not reference specific row numbers can be converted to column formulas. Use the following table as a guide when writing column formulas:
Reference Type |
Example |
Supported? |
---|---|---|
@row |
[Task Name]@row |
✓ |
Column references |
[Task Name]:[Task Name] |
✓ |
Cross sheet references |
{Task Name Column} |
✓ |
Cell references |
[Task Name]1 |
X |
Absolute references |
[Task Name]$1 |
X |
Partial-column ranges |
[Task Name]1:[Task Name]12 |
X |