IF Statement That Returns YES or NO

IF statement that returns Yes or No

To create an IF statement with text, you can use a formula like the one above.

1. Go to Formulas > New formula.

2. Click Switch to Advanced editor in the top-right corner.

3. Give the formula a title and enter your IF statement. Here's an example if your goal is to reach $50 000 in won deals this month:

   (IF(Sum(Deals,Status="won",Value)>50000,"Yes","No"))

   If you copy this formula into the formula editor, make sure to choose the data source, field, and filters based on your own data.

4. Change the number format to Text.

5. (Optional) Add conditional colors. For example, type in Yes for green and No for red.

6. Click Save in the bottom-right to finish.