Can you get a project level report to show which request types were or were not submitted

[TimothyBr]

Hello, and thanks for any support in advance! 

I am trying to run a project level report which would show all projects that DID NOT have a type of request submitted as an intra-project request. 

Overall example: We expect one of our teams to submit two intra projects requests; one at the start of a project and one at the end the "rank" the project. I am trying to think of a way without Fusion to flag when these HAVE NOT been submitted. Like a governing check to confirm who did not follow process. 

Thanks! 

[skyehansen · Accepted solution]

You can probably use EXISTS filters to get at a lot of this. However, it would depend on how you identify these requests, which isn't clear in your original post.

For example, if each of your requests uses a unique custom form, you can filter on projects which do not have a request that has custom form A or custom form B (or both). 

If the requests use a standard and consistent title, same: projects that do not have a request with title ABC or XYZ.

Or if the requests utilize unique queue topic names.

It's difficult to give you a more specific answer without some more information though -- as you can see, I've listed three different ways to submit these kinds of requests and each would be a different type of filter.