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 make changes to your reference directly in the formula, or, you can use the Reference Manager....
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.
Formulas in Smartsheet save time by calculating data automatically, combining cell contents in a sheet, and helping you keep track of dates, among oth...
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.