- logical_expression—An expression that evaluates to either true or false (boolean)
This example references the following sheet information:
|Clothing Item||Transaction Total||In Stock?||Sold Date|
Given the table above, here are some examples of using NOT in a sheet:
|=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 Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.