Listing Required fields not completed

Thanks for the response Everett.

I have a text field as my status and it is currently being changed via automation once all required fields are completed. The automation is based upon an additional field that uses a formula similar to the one you suggested, but it is:

If([Client Name] <> "" and [Subdivision Name] <> "" and [Location Address] <> "" and ([Contact Name] <> "" or [Related Contact2 - Contact Name] <> "" or[Related Contact3 - Contact Name] <> "" or [Related Contact4 - Contact Name] <> "" or [Related Contact5 - Contact Name] <> "" or [Related Contact6 - Contact Name] <> "" or [Related Contact7 - Contact Name] <>"") and [Total # of Jobs] >=1 and [Total # of Jobs]=[# of Scheduled Jobs] and [Type of Work Order] <> "" and [Is there a Closing/WO Deadline?] <> "","YES","NO")​

However, if not all required fields are completed and the Work Order is submitted, the user has no idea which field or fields is/are currently missing information so that the Work Order can move automatically to the Active status. They would have to go back through the different tabs, forms, etc., to visually identify which field is missing information. This is not fair to the user.

The suggestion you provided would allow me to change my Status based upon if a required field is blank or not.

Do you have a suggestion as to how I can identify which fields are missing information so that I can rely that to the user?

Thanks again for your input!