Embedded If Formula Help

Excelnoob69 

You've had over 60 views and no replies. I suspect that the issue here is that more definition is required, so let me first ask for some more clarification and suggest that, if at all possible, you give us access to the actual spreadsheet from which your image was taken.

Clarification: you go back and forth between referring to the deliverable(s) in the plural and in the singular, so let me ask you to clarify those various sentences. For example here's just one of your descriptive sentences, red being plural, green suggesting single/individual: "- If the deliverables have not been submitted but is due within the next 20 days, then it has Challenges Identified"

1. Are you looking for a status on each individual deliverable? Is that all you're seeking?
2. OR, are you also looking for some sort of collective result for each student with regard to his or her overall status, regardless of how many deliverables that individual student has?

If you can, please attach the sample spreadsheet to your reply. If that's not possible, grant us access to a copy in OneDrive, GoogleDrive, or some other comparable cloud service. That way we could get a more complete grasp of what you're working with. The image is helpful, but an actual working spreadsheet is far far better.