# Blue ball if 100 %

I designed a sheet in which a 100 % progress (available in a dropdown menu) should be automatically turn blue in another column

I tried to use an if formula but it is UNPARSEABLE

=IF(Fortschritt@row = "100%" ; "Blau")

What am I missing? Thx for help!

Tags:

## Best Answers

• ✭✭✭✭✭✭
Answer ✓

Please try this formula:

```=IF(Fortschritt@row = 1, "Blue")
```

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• ✭✭✭✭✭✭
Answer ✓

Please check the shared sheet i fix it for you.

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

## Answers

• ✭✭✭✭✭✭
edited 08/24/21

Hope you are fine, if your sheet using English language then the formula must be:

```=IF(Fortschritt@row = 1, "Blue")
```

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• @Bassam Khalil thx for the anwer, I changed it to "Blue" but now the field is empty

• ✭✭✭✭✭✭
Answer ✓

Please try this formula:

```=IF(Fortschritt@row = 1, "Blue")
```

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• @Bassam Khalil thx, it worked!

• ✭✭✭✭✭✭

Excellent, i will be happy to help you any time.

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• @Bassam Khalil sorry to bother you again.

Now I want to count all the blue, green, yellow and red balls in the "Status" column.

I switched to the summary section and tried a COUNTIF formula but without any result

• ✭✭✭✭✭✭

if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• ✭✭✭✭✭✭
Answer ✓

Please check the shared sheet i fix it for you.

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• Hi @Bassam Khalil once again you helped me! Thank you very much!

• ✭✭✭✭✭✭
edited 08/25/21

You are welcome, i will be happy to help you any time.

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!