If Statement Formula Unparseable

Options
Clem
Clem
edited 12/09/19 in Smartsheet Basics

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

Comments