Question on formula

jsimpe · 03/20/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.

Please help

Thanks,

Jeff Simper

Paul Newcome · 03/21/19

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

jsimpe · 03/23/19

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

jsimpe · 03/23/19

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

Thanks for your help.

Jeff

Paul Newcome · 03/25/19

Glad you were able to get it working. Happy to help.

Question on formula

Comments

Help Article Resources

Categories