# Formulas and Functions

## Formulas and Functions

#### Formula combinations for cross sheet references

There are countless ways to combine functions to analyze your data and make it more useful....

#### View, modify, or delete cross sheet references in formulas

You can make changes to your reference directly in the formula, or, you can use the Reference Manager....

#### Create cross sheet references to work with data in another sheet

Each cross sheet reference links to a single sheet. You can create multiple references to pull data from multiple sheets....

#### Create and Edit Formulas in Smartsheet

Use formulas to calculate numeric values or automate aspects of your sheet....

#### Create a Cell or Column Reference in a Formula

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....

#### Frequently asked questions about using formulas

Formulas in Smartsheet save time by calculating data automatically, combining cell contents in a sheet, and helping you keep track of dates, among oth...

#### Create Efficient Formulas with @cell and @row

Optimize your formulas to improve the overall performance of your sheet and prevent having to manually reference cells in formulas....

#### Combine (Concatenate) Text or Values from Two or More Cells with a Simple Formula

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....

#### Formulas: Reference data from other sheets

In Smartsheet, you can use formulas to perform calculations on data stored in a single sheet....

#### Formula Error Messages

A formula will return an error when Smartsheet expects different elements from the formula than what are provided....

#### Use Formulas to Perform Calculations With Dates

You can place a formula in one cell (formatted with a Date column type) that adds or subtracts numbers from dates in other cells....

#### Reference Children, Parents, and Ancestors with Hierarchy Functions

You can use hierarchy in Smartsheet to indent or outdent groups of cells to better show relationships between groups of data....