IF(OR(ISBLANK) Statement

Duane B
Duane B ✭✭✭
edited 12/09/19 in Formulas and Functions

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"))))

Comments

  • Lee Joramo
    Lee Joramo ✭✭✭✭✭✭

    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

  • Duane B
    Duane B ✭✭✭

    That worked!  Thanks.

  • Lee Joramo
    Lee Joramo ✭✭✭✭✭✭

    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!