I am trying to setup a workflow trigger to tell the users when a report package is ready for the next phase. We've added an optional task in that process for when there are revisions that need to be done between the reviews. So, I need to know when one or both tasks (if it exists) are completed before signaling that the next stage should begin.
This is an example of the single task formula I am currently using in a Checkbox Field.
If([# of Completed 1st Reviews]>0, true, false)
How would I get the same thing to happen if it needed to also check for the 1st Revisions task? There is a field on the record that says the 1st Revisions task is needed.
Parent Record is Reports, Child Record Tasks, and "# of ____" fields are summary fields on the Parent records.
------------------------------
Jennifer Peterson
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.