If Statement Formula Unparseable

Clem

Anybody able to explain why the following formula is coming up as #UNPARSEABLE

=IF(AND(ISBLANK([Contractor CO Submittal Date]@row), ISDATE([Company CO Response Date]@row), [Company Response]@row = "New CO to Contractor"), "Contractor Response Needed", IF(AND(ISDATE([Contractor CO Submittal Date]@row), [Contractor CO Submittal Date]@row = <[Company CO Response Date]@row, OR([Company Response]@row = "Needs More Info", [Company Response]@row = "Countered")), "Contractor Response Needed", IF(AND(ISDATE([Contractor CO Submittal Date]@row), [Contractor CO Submittal Date]@row = <[Company CO Response Date]@row, OR([Company Response]@row = "Approved", [Company Response]@row = "Change Directive", [Company Response]@row = "Rejected")), "Closed", IF(AND(ISBLANK([Contractor CO Submittal Date]@row), ISDATE([Company CO Response Date]@row), [Company Response]@row = "Change Directive"), "Close", IF(AND(ISDATE([Contractor CO Submittal Date]@row), ISBLANK([Company CO Response Date]@row), ISDATE([Company Response]@row)), "Company Response Needed",)))))

Andrée Starå

Hi Clem,

At a glance, I can see at least two errors. Less than or equal to ( =<) have to be changed to (<=) otherwise you'd get an #Invalid Operation error.

My recommendation would be to break down all the parts and make sure that each is working as it should because it's much easier to find what's wrong in that way.

Hope that helps!

Let me know how it goes!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

L_123

Also the comma at the end needs to be deleted. If there isn't a false return, then don't add the comma or do

,""

 

Mike Wilday

Yep, other than those two suggestions by Andree and L@123 things seem to be in shape.