#UNPARSEABLE with multiple IF statements

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?

Find more posts tagged with

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Logging separate data points of the same type of data for one row
Looking for a way to easily log and reference multiple data points for the same type of data (ex: successful phone contacts) that all show for one entry (by member name). Want this to be both easy to enter the information (ideally by interacting with the same row via Dynamic View), and easy to see data on the back end of…
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
Create Formula at Grouping level
Hi, I have a source (and detailed) Smartsheet page with a lot of "detailed" transactions/rows. I created a report where I'd like to group the data and get some subtotals at the same time. If you check the picture (my new report), I'd like to group by "Task Name" , sum the "Hours", return the max of the "Estimated duration"…