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