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....
Each cross sheet reference links to a single sheet. You can create multiple references to pull data from multiple sheets....
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.
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice...
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.