Blue ball if 100 %

Alexander Gottschalk

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!

Bassam Khalil

@Alexander Gottschalk

Please try this formula:

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

Bassam Khalil

@Alexander Gottschalk

Please check the shared sheet i fix it for you.

Bassam Khalil

Hi @Alexander Gottschalk

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

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

Alexander Gottschalk

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

Bassam Khalil

@Alexander Gottschalk

Please try this formula:

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

Alexander Gottschalk

@Bassam Khalil thx, it worked!

Bassam Khalil

@Alexander Gottschalk

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

Alexander Gottschalk

@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

Bassam Khalil

@Alexander Gottschalk

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 Khalil

@Alexander Gottschalk

Please check the shared sheet i fix it for you.

Alexander Gottschalk

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

Bassam Khalil

@Alexander Gottschalk 

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