IF Statement

Sandra Vulis Petrosyan

Hello all

I am trying to come up with IF statement for a Smartsheet form. For example, if a cell has a specific "term" in the sentence, can that trigger a number to populate in an adjacent column?

In the example below, I would like the IF statement (in the product column) to trigger a "score" based on the specific term in the "enter the project description". In this case, I would like "apples" to trigger the number 9 in the product column. Is this possible?

Toufong Vang

Hi, Sandra.

You can use the function, CONTAINS().

=IF( CONTAINS("apples", [Enter the Project Description]@row), 9, "Something else.")

Be advised, CONTAINS() will also work if you launched "pineapples" instead.

Documentation for CONTAINS() can be found here, https://help.smartsheet.com/function/contains.

Other functions that you can use to perform searches are: FIND(), HAS(), MATCH(). The list of Smartsheet functions can be found here, https://help.smartsheet.com/functions.

Cheers!