The ABS function offers a way to ensure that your result is always positive. This function removes a negative state without changing the numeric … ABS …
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 a … AN …
Used within another function to return true if all provided logical expressions are … AND …
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 … AVG …
Returns a weighted average (the mean, where each value is weighted by its relative … Returns a weighted average (the mean, where each value is weighted … AV …
The TODAY function in Smartsheet returns the current date within formulas. … The TODAY function in Smartsheet returns the current date within … Users on an … A …
Rounds a number away from zero to the nearest specified multiple of significance … Rounds a number away from zero to the nearest specified multiple of … CEI …
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 … CHILDREN …
Used within another function to select specific values in a range that meets the provided … COLLECT …
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 … CONT …
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 … COUNTIFS …
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 … COU …
You can combine multiple cells to join values together in a text chain or series. … You can combine multiple cells to join values together in a text … Users …
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 … Use …
When you create formulas, you can include values from other cells or columns on the … When you create formulas, you can include values from other cells … Us …
Work with data from other sheets with cross-sheet references. Each cross-sheet reference links to a single sheet. You can create multiple references … Wo …