Expand my Community achievements bar.

The Community Advisors application is now OPEN for the second class of 2024. Apply to become a part of this exclusive program!

Report: Adding whether there is a document (yes or no) from a particular task and folder

Avatar

Level 2

Okay, so this one may be a bit convoluted, but here's what I'm trying to do:

 

I need to create a report that says (true/false) if there are documents inside a task's folder.  I've built a report for this, but it's pulling in all documents, not just from a specific folder.  I added a field called "has documents" but that's what is pulling everything, so I know that's not right.

 

I have a Task Named QC.  There's a folder at the QC task level called QC.  I want the report to show if there are documents in that task folder.  If yes, I want the report to say True (or yes) and if not, I want it to say False (or no).  Perhaps with a option for "blank" - not the word, just a blank.  Blank could/may indicate new project.  

 

Let me know if you have questions...

 

Thank you!

Tracy

0 Replies