# IF(OR(ISBLANK) Statement

Options
✭✭✭
edited 12/09/19

I am trying to set a colored dot to Green if the project is on time, Red if it is late and Yellow if it is not started ([Date Completed] = blank).  The Red and Green work, but I cannot get the yellow dot.  Any help would be greatly appreciated.  This is the formula as it stands.

=IF(OR(ISBLANK([Date Completed]1, "Yellow"), IF([Date Completed]1 - [Scheduled Date]1 <= 0, "Green", IF([Date Completed]1 - [Scheduled Date]1 > 0, "Red"))))

Tags:

## Comments

• ✭✭✭✭✭✭
Options

This should work for you. Your formula was incorrectly written around the ISBLANK function. Formatted for reading:

=IF (

ISBLANK([Date Completed]1),

"Yellow",

IF (

[Date Completed]1 - [Scheduled Date]1 <= 0,

"Green",

IF (

[Date Completed]1 - [Scheduled Date]1 > 0,

"Red"

)

)

)

and for copy and paste:

=IF ( ISBLANK([Date Completed]1), "Yellow", IF ( [Date Completed]1 - [Scheduled Date]1 <= 0, "Green",  IF ( [Date Completed]1 - [Scheduled Date]1 > 0, "Red" ) )

)

--

Lee Joramo

Data Integrations Developer - Mesa County Valley School Dist. 51

970-254-5104  x11556

• ✭✭✭
Options

That worked!  Thanks.

• ✭✭✭✭✭✭
Options

This forum is not allowing me to correct the formatting of the copy and paste test.  Here it is again:

=IF(ISBLANK([Date Completed]1), "Yellow", IF([Date Completed]1 - [Scheduled Date]1 <= 0, "Green",  IF([Date Completed]1 - [Scheduled Date]1 > 0, "Red" )))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!