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 and Edit Formulas in Smartsheet

Use formulas to calculate numeric values or automate aspects of your sheet....

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

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

Subscribe to Formulas and Functions

Language:

Search form

Help Articles

Formulas and Functions