Used within another function to provide the opposite of a logical expression
Sample Usage
IF(NOT(Status1 = "Complete"), "Task Not Complete", "Task Complete")
Syntax
NOT(
- logical_expression
- logical_expression—An expression that evaluates to either true or false (boolean)
Examples
This example references the following sheet information:
| Clothing Item | Transaction Total | In Stock? | Sold Date | |
|---|---|---|---|---|
| 1 | T-Shirt | 1,170.00 | true | 02/12/19 |
| 2 | Pants | 1,491.00 | false | 02/15/19 |
| 3 | Jacket | 812.00 | true | 02/20/19 |
Given the table above, here are some examples of using NOT in a sheet:
| Formula | Description | Result |
|---|---|---|
| =IF(NOT([In Stock?]1 = true), "Out Of Stock", "In Stock") | Returns the string Out Of Stock if the value in row 1 of the In Stock column does not equal true. Otherwise, the function returns the string In Stock. | In Stock |
| =COUNTIF([Clothing Item]:[Clothing Item], NOT(@cell = "Jacket")) | Counts values that aren't equal to the string Jacket in the Clothing Item column. Rows 1 and 2 apply. | 2 |
| =IF(NOT(YEAR(TODAY())= YEAR([Sold Date]3)), "Sale did not occur this year", "Sale occurred this year") | Returns the string Sale did not occur this year if the year in row 3 of the Sold Date column isn't equal to the current year. (In this example, the current year is 2019.) Otherwise, the function returns the string Sale occurred this year. | Sale occurred this year |
Still need help?
Use the Formula Handbook template to 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.