#UNPARSEABLE with multiple IF statements

Steve Burks

Hi,

I am trying to create TEXT depending on some conditional information.

I want to display text RED if my materials clear date is less than 7 days from my due and display text YELLOW if my materials clear date is less than 14 days (but greater than 7 days) and if my materials clear date is greater than 15 days, leave the cell blank.

Here is the formula I came up with -

=IF([Original Promised Ship Date]@row +7 < [Materials Clear]@row, “RED”, IF([Original Promised Ship Date]@row +14 < [Materials Clear]@row, “YELLOW”, IF([Original Promised Ship Date]@row +15 < [Materials Clear]@row, “”)))

What am I missing here?

Andrée Starå

Hi @Steve Burks

I hope you're well and safe!

At a glance, you have slanted "". I'm guessing you probably wrote the formula in Word or similar, correct?

Try something like this.

=IF([Original Promised Ship Date]@row +7 < [Materials Clear]@row, "RED",

IF([Original Promised Ship Date]@row +14 < [Materials Clear]@row, "YELLOW",

IF([Original Promised Ship Date]@row +15 < [Materials Clear]@row, "")))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

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

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

Steve Burks

Hi Andree,

Yes and no. Thank you for pointing this issue out with the quote sign.

It did not work as expected, but that was because my logic was backward. I used + days instead of - days. Here is the corrected version -

=IF([Original Promised Ship Date]@row - 7 < [Materials Clear]@row, "RED",

IF([Original Promised Ship Date]@row - 14 < [Materials Clear]@row, "YELLOW",

IF([Original Promised Ship Date]@row - 15 < [Materials Clear]@row, "")))

Yes, I did use Word. Is there a setting in Word to use the correct quote symbol? I only ask because it is much easier to review in Word instead of the actual sheet. I am open to another suggestion as well.

Andrée Starå

@Steve Burks

Excellent!

Happy to help!

Are you on Mac or PC?

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

Steve Burks

I am on a PC.

Andrée Starå

@Steve Burks

I'd recommend one of these.

Visual Studio Code.

Notepad++

Steve Burks

I will use Notepad++

Thank you again for all of your help! Have a great weekend.

Andrée Starå

@Steve Burks

You're more than welcome!

Thanks, and likewise!

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