Question on formula

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

Find more posts tagged with

Formulas

Comments

Paul Newcome

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

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

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

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

Sign in to join the conversation!

Quick Links

Trending discussions

Countif, index/match
I'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
Help creating formula to return a date in a column that is closest to today's date
I need help creating a formula that references the "Due in Payroll" column I have which is a series of dates. I would like the formula to look at that date column, and return whichever date in that column is closest to today's date. I've tried several formulas, all come up invalid column type, unparseable invalid…
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…