# Problems figuring out nested-IF formula

edited 12/09/19

I'm having difficulty figuring out what is wrong with my formula in attempting to use a nested-if formula to automate the RYG light in the "Status" column, depending on the "% Complete" column.

Here is my formula:

=IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3 => 0.7, "Yellow, [% Complete]3 < 1.0, "Yellow", IF([% Complete]3 = 1.0, "Green")))

Can anyone assist? Thanks,

Tags:

• ✭✭✭✭✭✭

I think the primary issue is your => it should be >=

=IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3  >= 0.7, "Yellow, [% Complete]3 < 1.0, "Yellow", IF([% Complete]3 = 1.0, "Green")))

Try this rendition.

• I appreciate the quick assist Mike. I put your rendition in and still not coming out. That adjustment does make sense though. If you think of anything else I'd gladly take the recommendation. Thank you!

• ✭✭✭✭✭✭

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

• ✭✭✭✭✭✭

Oh! The AND statement wasn't formatted correctly either. Totally missed it! Try this one.

=IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3  >= 0.7, [% Complete]3 < 1), "Yellow", IF([% Complete]3 = 1, "Green")))

• Brilliant! Thank you sir, that was it. Greatly appreciated. Have yourself a wonderful weekend!