I want "In progress" to display if the check # field is blank or CCC Approved field is Yes, otherwise I want "Complete" to display. I've tried this formula but the syntax is wrong.
=IF(ISBLANK([Check #]1), "In Progress", IF([CCC Approved?]1=YES, "In Progress", "Complete"))