"IF" function question - Urgent if possible


I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked.

Can someone explain how this can be done?

Example: EDI setup-completed, testing successful check box checked, contracted check box checked


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!