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"))

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.