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...
Formula Error Messages
A formula will return an error when Smartsheet expects different elements from the formula than what are provided....
Create Efficient Formulas with @cell
When you want to perform calculations in formulas that look at ranges of cells, for example: SUMIF, SUMIFS, COUNTIF, and COUNTIFS, you can use the @ce...
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...