Create and Edit Formulas in Smartsheet
Use formulas to calculate numeric values or automate aspects of your sheet....
Formulas and Functions
Functions List for Smartsheet Formulas
See the complete list of Smartsheet functions. Use functions in formulas to manipulate data, to add or subtract dates, or to make calculations—to name just a few things you might want to do...
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....