The TODAY function in Smartsheet returns the current date within formulas.
This article includes some frequently used functions and additional resources to help you make the most out of formulas.
You can edit a reference directly in your formula without opening the Sheet Reference Manager. Select the cell that contains your formula....
Work with data from other sheets with cross sheet references.
Use formulas to calculate numeric values or automate aspects of your sheet.
When you create formulas, it's possible to include values from other cells or columns on the sheet.
Users on an Enterprise plan can use AI to generate formulas. Learn more....
Optimize your formulas to improve the overall performance of your sheet and prevent having to manually reference cells in formulas.
You can combine multiple cells to join values together in a text chain or series.
You can perform formula calculations across sheets, using those results to give you a higher level picture of what’s happening with your
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.
Hierarchy functions allow you to include cells in other functions based on their indent level in a sheet.