IF Statement

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!