Check for all task status when project is closed

Ou can summarize the # of tasks which are incomplete. 

Then you can have a form rule which says that when the record is saved and the status is Complete and the # of tasks which are incomplete > 0, abort the save with a message. 

Hello,

Thank you for the feedback.  I have what you suggested mostly working.   The only issue that I have is that if the task status is changed within the project form in grid edit mode, the task status summary field does not update and thus I cannot save the project (if I also mark the project as closed).  In other words, if I edit the project and close all tasks via grid edit and mark the project as closed, I cannot save.

Any ideas on how to get around that?

Thanks again.

Hmmm, yes that is tricky.  You could kill that form rule and instead have an Automation fire when Project is saved and the Status is complete and there are still open tasks.  The Automation would reset the status back to some other status like "in progress" or perhaps better yet, "reopened due to tasks still being opened", and then also set an email to fire saying "sorry, but your project has been re-opened as it still has incomplete tasks."

Now, the question is who to fire the email to as the [Last Modified by] will be the Automation owner and not the person who tried to close the project.

So the first step in that Automation will need to be to copy the value in the field [Last Modified by] to a field called [Who to Notify of a Status reversal]. Then you have a field to email to.

I'm not overly familiar with how the Automation feature works at the Application level so I'll need to play around with that.

Also, on the Form rule that I built, the message that displays on Abort Save shows not only the message that I created but also all the criteria that needs to be satisfied in order to Save.  So the message is kind of messy.  Is there a way to exclude the criteria from the message?