I need to create a report that shows me all projects where my Custom Field of Proof Readers is blank AND contains the task of Get Packaging Creative Approved and DOES NOT contain Creative Approval. I can get halfway there but am struggling with the OR statement. I think I am missing something simple. Anyone has any ideas. Here is my starter code below.
tasks:name=Get Packaging Creative Approved
Topics help categorize Community content and increase your ability to discover relevant content.
I'm going to see if @Sarah Nau‚ or @Jonathan Hobbs‚ who are both great at reporting have any ideas for you here!
Thanks in advance guys for seeing if you can help out.
My guess is, "Creative Approval" is the task name?
If you want to filter for projects where a creative approval task is missing, that would be an exists statement added to your textmode. You can read more about exists statements here: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe...
You are specifically looking for this section: "You must use an EXISTS statement to do the following:
It might be as simple as just adding the four lines below to your code, but I would definitely test this before relying on it.