# Question on formula

Options
edited 12/09/19

I would like to add a check for blanks in the following formula using 2 date columns.  My current formula is returning a "yes" when there are blank cells.  I am using this for a KPI metric.

=IF([KPI | Actual Sizing Completion]7 <= [KPI | Target Sizing Completion]7, "yes", "no")

I have tried numerous combinations of ISBLANK, "", Date but cannot get the correct syntax.

Thanks,

Jeff Simper

Tags:

• ✭✭✭✭✭✭
Options

How/where would you want it worked in? From the sound of it you would use something along the lines of

AND(ISBLANK([Date Column 1]7), ISBLANK([Date Column 2]7))

• Options

Paul,

Thank you so much for your reply.  I attempted to combine the suggestion from you with my original.  (This is starting to move beyond my comprehension level.)  Below is what I tried.  I am getting an Incorrect Argument error.

=IF(AND(ISBLANK([KPI | Target Sizing Completion]7), ISBLANK([KPI | Actual Sizing Completion]7), IF([KPI | Actual Sizing Completion]7 <= [KPI | Target Sizing Completion]7, "yes", "no")))

Any suggestions would be appreciated.

Again, what I am trying to do is the following:

Check to see if either date column is blank.  If either is blank, do nothing.  If dates are found in both columns, ask if  "Actual date column" is less than or equal to "Target date column".  When true return "yes", otherwise "no".

Jeff Simper

• Options

Paul,

I just had success.  I decided I only needed to check the actual date column for blank.  the following is working: =IF(NOT(ISBLANK([KPI | Actual Sizing Completion]6)), IF([KPI | Actual Sizing Completion]6 <= [KPI | Target Sizing Completion]6, "yes", "no"))