# IF Formula

Options

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

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Thanks for your feedback, it helps and works.

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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

• ✭✭✭✭✭✭
Options

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.

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!