The ABS function offers a way to ensure that your result is always positive. This function removes a negative state without changing the numeric …
To learn more about Smartsheet Regions, click here.
Formulas and functions
Used within another function to reference all the ancestors in a cell’s hierarchy … Used within another function to reference all direct ancestors in …
Used within another function to return true if all provided logical expressions are true. … …
Returns the average of a range of numbers that meet a given criteria … AVERAGEIF …
Returns the average (mean) of the provided numbers. … Returns the average (mean) of the provided numbers … …
Returns a weighted average (the mean, where each value is weighted by its relative importance) … Returns a weighted average (the mean, where each …
The TODAY function in Smartsheet returns the current date within formulas. … The TODAY function in Smartsheet returns the current date within …
Rounds a number away from zero to the nearest specified multiple of significance … Rounds a number away from zero to the nearest specified multiple …
Converts a number into a character … Converts a number into a character … CHAR …
Use this function to reference column values of a parent row's child rows. … Use this function to reference column values of a parent row's child …
Used within another function to select specific values in a range that meets the provided criteria … …
Is used within another function to search for a character or string. It will return "True" if it found the character or string. Otherwise, it will …
Counts nonblank values … COUNT …
Counts the number of cells within a range that meet a criterion. … COUNTIF …
Counts the number of times all given conditions in their respective ranges are met. … …
Counts the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total …
You can concatenate cell values or combine them with a delimiter to create a series. … You can combine multiple cells to join values together in a …
Use formulas to calculate numeric values or automate aspects of your sheet. You can create formulas, for example, to sum a range of expenses, or to …
When you create formulas, you can include values from other cells or columns on the sheet. … When you create formulas, you can include values from …
Work with data from other sheets with cross-sheet references. Each cross-sheet reference links to a single sheet. You can create multiple references …