Nested If/And Statement

rkw

I am trying to figure out a nested IF/AND statement that will alert me if an estimate is older than 90 days and a work order has not yet been started.  I simply have a 'Needs Attention' column that will show a checkmark if this is the case and otherwise just displays an empty checkbox.  My formula below works as it should if the 'Estimate Creation Date' entered is within 90 days (result is empty checkbox), but it gives me an "Incorrect Argument Set" error if the date entered is older than 90 days. 

=IF(AND([Estimate Creation Date]127 < TODAY() - 90), ISBLANK([Work Order Date]127, 1))

I don't understand why this is happening.  Anyone know what would be causing this and how to fix?  I would really appreciate any help.  Thanks--

Mike Wilday

You're closing the AND argument too early.

=IF(AND([Estimate Creation Date]127 < TODAY() - 90, ISBLANK([Work Order Date]127), 1)

Try that. That should do the trick. 

rkw

Thanks for the response, Mike.  After making the change you suggested, I am now getting the 'Incorrect Argument Set' error with any date I enter so something is still not right.  

rkw

I changed the order of my formula and got it working, as follows:

=IF(AND(ISBLANK([Work Order Date]127), [Estimate Creation Date]127 < TODAY() - 90), 1)

Thanks again for responding to my post, Mike.

 

Mike Wilday

How peculiar! I am glad you got it working. 

Happy to be of help!