-
range
-
n
-
range—The group of numbers to return the n-th lowest value from
-
n—A number representing the position, from the lowest, to return
- SMALL will only look at numbers in the given range. If the range doesn’t contain numbers, you’ll receive an #INVALID VALUE or #INVALID COLUMN VALUE error.
- If thenvalue ishigherthan the total number of values in the range, you'll receive an #INVALID DATA TYPE error.
This example references the following sheet information:
Row # |
Clothing Item |
Units Sold |
Price Per Unit |
存货吗? |
|---|---|---|---|---|
1 |
t恤 |
78 |
$15.00 |
false |
2 |
Pants |
42 |
$35.50 |
true |
3 |
Jacket |
217 |
$200.00 |
true |
Given the table above, here are some examples of using SMALL in a sheet:
Formula |
Description |
Result |
|---|---|---|
=SMALL([Price Per Unit]:[Price Per Unit], 1) |
Returns the 1st smallest number in thePrice Per Unitcolumn |
$15.00 |
=SMALL(COLLECT([Price Per Unit]:[Price Per Unit], [In Stock?]:[In Stock?], 1), 1) |
Returns the 1st smallest number in thePrice Per Unitcolumn where the values in theIn Stockcolumn are 1 (checked/true). |
$35.00 |
=INDEX([Clothing Item]:[Clothing Item], MATCH(SMALL([Units Sold]:[Units Sold], 1), [Units Sold]:[Units Sold], 0)) |
Returns the value in theClothing Itemcolumn that has the smallest number ofUnits Sold |
Pants |
Still need help?
Use theFormula Handbook templateto find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.