jeudi 17 janvier 2019

IF statement is ignoring my IF Blank Rule

I am working in MicrosoftSharepoint and I am trying to create a calculated column to show status, based off of a different date column. there are three rules or results based on the dates in the column, aswell as an IF statement to try to leave the cell blank if there is no date in the corresponding cell. The code goes through but when the removal date column has a blank cell, the corresponding cell in the status column is not left blank but just randomly filled with one of the status's from the other rules.

I have tried the different ways to work around a blank cell from https://exceljet.net/formula/if-cell-is-blank, but have not made any progress. I tried re arranging the order of my formula but then would get a syntax error.

=IF( [Win7 Removal Date] < TODAY(

),
"Resubmit for approval",
 IF(
    AND(
        ( [Win7 Removal Date] -
            TODAY(

            ) ) >= 0,
        ( [Win7 Removal Date] -
            TODAY(

            ) ) <= 14
    ),
    "At Risk",
     If(
        ( ( [Win7 Removal Date] -
                TODAY(

                ) ) > 14 ),
        "On Track",
         IF(
            [Win7 Removal Date] = "",
            "No Date",
            ""
        )
    )
)

)

If the cell in the "Win7 Removal Date is blank, the cell in the new column should be blank as well. because as of now those cells are being filled with "Resubmit for approval"

Aucun commentaire:

Enregistrer un commentaire