Formulas and Functions

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

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....

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...

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

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....

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

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

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

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