With helper columns, you can simplify complex operations, solve specific problems, track progress, calculate dates, automate alerts
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.
Formulas in Smartsheet save time by calculating data automatically, combining cell contents in a sheet, and helping you k
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.
A formula will return an error when Smartsheet expects different elements from the formula than what are provided.
You can enter a formula in a cell as part of a Date column to add or subtract numbers from dates in other cells.
Hierarchy functions allow you to include cells in other functions based on their indent level in a sheet.