Formulas and Functions

Formulas and Functions

Create and Edit Formulas in Smartsheet

New! Formulas can now be placed in Contact List fields. Automatically assign people to tasks with a VLOOKUP formula, for example....

Create a Cell or Column Reference in a Formula

When you create formulas, it's possible to include values from other cells or columns on the sheet. You do this with cell or column references....

Frequently Asked Questions About Using Formulas

Formulas in Smartsheet can save you time by calculating data automatically, by combining cell contents in a sheet, or by helping you keep track of dat...

Create Efficient Formulas with @cell and @row

Optimize your formulas to improve the overall performance of your sheet, and prevent having to manually reference cells in formulas....

Combine Text from Two or More Cells with a Simple Formula

If you want to combine text from two or more cells into a different cell (concatenate the values), you can do this with a simple formula....

Formulas: Reference Data from Other Sheets

Perform calculations on data that is stored in another sheet....

Formula Error Messages

A formula will return an error when Smartsheet expects different elements from the formula than what are provided....

Use Formulas to Perform Calculations With Dates

You can place a formula in one cell (formatted with a Date column type) that adds or subtracts numbers from dates in other cells....

Reference Children, Parents, and Ancestors with Hierarchy Functions

You can use hierarchy in Smartsheet to indent or outdent groups of cells to better show relationships between groups of data....