IF Formula

Abdelhadi Said

Hello,

could you help me understand what is wrong with this IF Formula?

I refer to the link below with the formula =IF([Order Date]3 < TODAY(), "Red", IF(AND([Order Date]3 >= TODAY(), [Order Date]3 < TODAY(+7)), "Yellow", "Green"))

My formula =IF([% Complete]@row < 70%, ''RED'', IF(AND([% Complete]@row <= 70%, [% Complete]@row < 100%), ''Yellow'', ''Green''))

I tried with replacing the % by 0.7 or 1, but doesn't work. it's for RYG status ball.

Thanks

Andrée Starå

Hi @Abdelhadi Said

You had some other characters surrounding the True or False results, and the RYG colors have to be Red or red, but not RED. Also, you had a more than/less than statement flipped.

Try something like this.

=IF([% Complete]@row < 0,7, "Red", IF(AND([% Complete]@row >= 0,7, [% Complete]@row < 1), "Yellow", "Green"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Abdelhadi Said

You had some other characters surrounding the True or False results, and the RYG colors have to be Red or red, but not RED. Also, you had a more than/less than statement flipped.

Try something like this.

=IF([% Complete]@row < 0,7, "Red", IF(AND([% Complete]@row >= 0,7, [% Complete]@row < 1), "Yellow", "Green"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Abdelhadi Said

Hi @andree@workbold.com

Thanks for your feedback, it helps and works.

Andrée Starå

@Abdelhadi Said

Excellent!

You're more than welcome!

Abdelhadi Said

Just one thing, need to put . not , exp 0.7 and not 0,7

Andrée Starå

@Abdelhadi Said

Yes, sorry about that. I usually add the formula options for different localisations.

Depending on your country/region, you'll need to exchange the comma for a period and the semi-colon for a comma.