OR Function | Smartsheet Learning Center

Used within another function to return true if at least one provided logical expression is true.

Sample Usage

IF(OR([Due Date]1 > [Due Date]2, [Due Date]1 > [Due Date]3), "Due Date 1 isn't the smallest", "Due Date 1 is the smallest")

Syntax

OR(

logical_expression1
[
- logical_expression2
- ...
]

)

logical_expression1
—
An expression that evaluates to either true or false (boolean)
- logical_expression2
- ...
—[optional]
Additional expressions that evaluate to true or false

Usage Notes

OR can be used directly in a boolean column (checkbox, flag, star) or can be used within another function—such as IF, SUMIF, COUNTIF, SUMIFS, and COUNTIFS
OR can be used directly in a boolean column (checkbox, flag, star) or can be used within an IF function
OR can also be used in conjunction with @cell, in the criterion of other functions such as SUMIF, COUNTIF, SUMIFS, and COUNTIFS

Examples

This example references the following sheet information:

Row #	Item Number	存货吗?	Status	Units Sold
1	C001	true	Green	78
2	C002	false	Red	42
3	C003	true	Yellow	217
4	C004	true	Yellow

Given the table above, here are some examples of using an OR() function in a sheet:

Formula	Description	Result
=IF(OR([In Stock?]1 = 0, Status1 = "RED"), "Check Order Status and Stock", "On Track")	If the first row of theIn Stockcolumn is equal to 0 (un-checked/false); or, the first row of theStatuscolumn isRed, return the valueCheck Order Status and Stock, if not return the valueOn Track	On Track
=IF(OR([Units Sold]2 > 50, [In Stock?]2 = 0), "Out Of Stock", "In Stock")	If the second row of theUnits Soldcolumn is greater than 50; or, theIn Stockcolumn equals 0, return the valueOut Of Stock,if notIn Stock	Out Of Stock
=COUNTIF(Status1:Status4, OR(@cell = "Green", @cell = "Yellow"))	Count the number of values in theStatuscolumn ifGreenorYelloware returned at the cell level; rows 1, 3, and 4 apply.	3

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.

Ask the Community