IF formula

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!