You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Search for requisitions that have no attachments

Question
17
Views
0
Comments

Summary

Need help with formulas/filters

Content

Dear All,

We are doing an audit on our requisitions and one of the audit items is to look for interview evaluation sheet attached to the requisitions.

I was trying to only pull requisitions that have no attachments, or attachments that don't have pdf. file. please see image 1

 

The methods I have tried include

1. Transaction event type is not equal to "File Attached%"

2. Transaction event type description does not contain "File Attached%"

Neither of them gives me 100% accurate data, the accuracy is about 80% to 90%. Some requisitions with pdf file attached still show up in the report. We also don't have a naming convention on the attached file so it becomes difficult for us. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!