"IF" function question - Urgent if possible

Daniel Pochop

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

Paul Newcome

Are you able to provide more detail as to your setup and process? Are you able to provide a screenshot for context with sensitive/confidential data removed, blocked, or replaced with "dummy data" as necessary?

Based on your initial description, it should be possible.

Daniel Pochop

I was able to figure out the following so far: =IF(AND([EDI Status]62 = "Complete", [Procurement Status]62 = "Complete"), "All Tasks Complete", "In Progress")

Im trying to see how to add in if a status shows cancelled or NA that if defaults to a certain key, if that makes sense.

Paul Newcome

I'm not sure I follow. Can you provide an example?