There are countless ways to combine functions to analyze your data and make it more useful....
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. You do this with cell or column references....
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....
If you want to combine text from two or more cells into a different cell (concatenate the values), you can do this with a simple formula....
In Smartsheet, you can use formulas to perform calculations on data stored in a single sheet....
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....
You can use hierarchy in Smartsheet to indent or outdent groups of cells to better show relationships between groups of data....