Reduce result to single answer using collections

Hi Community,

I know written something disgusting here, which is returning 4 answers. In this example, the project holds 4 documents, and I’m only interested in proofs that don’t contain the word “Quote”. Two documents are not proofs (so want to ignore these), and the two proofs contain four proof versions between them.

I’m not sure if I’m getting an answer per document. The actual answer I’m looking for with this example is “No”, as the first proof version was created after the estimate date. This proof doesn’t contain “Quote”. Screenshot, shows the results.

Code:

displayname=Within Deadline?
listdelimiter=<p>
listmethod=nested(documents).lists
type=iterate
valueexpression=IF(IF(!ISBLANK({ID})&&!CONTAINS("Quote",{name}),{project}.{DE:C+D Creative Deadline},"")<=(IF(!ISBLANK({ID})&&!CONTAINS("Quote",{name}),{entryDate},"")),"Yes","No")
valueformat=HTML

Results

If you’ve read this far, thanks for your time 😊

Matt