IF and ISBLANK For Color Statuses

Question

Hello All,

I'm running into issues with my IF and ISBLANK formulas that will determine the color statuses.

Here are my columns.

Column 1- "Phase 2", this is a date field.

Column 2- "Sell Date", this is a date field.

Column 3- "RAMP", this is a symbols field, with the colors Red, Yellow and Green.

Here's what I'm looking to accomplish:

Column 3 should reflect Red if both "Column 1 & 2" are blank.

Column 3 should reflect Yellow if "Column 1" has a date and "Column 2" is blank

Column 3 should reflect Green if both "Column 1 & 2" have dates

Here is my current formula which gets my half way but not all the way.

=IF(ISBLANK([Phase 2]1), "Red", "Green")

I've tried to add the following to prompt the yellow but have been unsuccessful.

=IF(ISBLANK([Phase 2]1), "Red", =If(ISBLANIF(NOT(ISBLANK([Phase 2]1) AND IF(ISBLANK([SELL DATE]1), "Yellow"

Any help would be greatly appreciated as I've exhausted all my brain cells trying to get this to work.

THANK YOU!

Mike Wilday · Accepted Answer

HI @Justin Landry

The AND forumula is a unique entitity and requires a slight rewrite to your formula.

The And formula requires the grouping of two conditions within brackets, separated by comments.

Example:

AND(ISBLANK([Sell Date]1), Isblank([Phase 2]1))

So as you write out your formula, it would be something like this... IF(ISblank([Phase 2]1), "Red", IF(AND(ISBLANK([Sell Date]1), Isblank([Phase 2]1)), "Yellow", "Green"

You have to carefully open and close the and statement to make it work properly but this example should get you started.

Mike Wilday · Accepted Answer

There is one slight mistype that I see. You closed the isblank formula but you never closed the NOT formula here is how it should look. Try this, but if this doesn't work then you can try deleting the last closed parenthesis and pasting it in.

=IF(ISBLANK([Phase 2]1), "Red", IF(AND(NOT(ISBLANK([Phase 2]1)), ISBLANK([Sell Date]1)), "Yellow", "Green"))