@MoniqueEvans just kidding, I figured it out : ) If anyone wants to have a column showing wait time on a proof approval report, not a document version report, it's: displayname=Wait Time shortview=true valueexpression=CONCAT(ROUND(WEEKDAYDIFF({proofCreationDate},$$TODAY),1)," Days") valueformat=HTML

Hi @MoniqueEvans! I can't figure out how to adjust this text mode to use in a column in a proof approval report. I've tried documentVersion:entry date and other variations. Would really like this in a proof approval report given that's where my other proof approval reports are. Thoughts?I've looked ...

I'd use a Note report and you can filter specific teams using Team ID = XYZ or if you're looking for ANY team tagged, use Team ID is not blank. Since you'll probably get a ton of results I'd at least filter it to certain projects or a timeframe of note entry like the example below:  

It's kind of insane this isn't possible by now (to my knowledge) - please upvote this Idea about it! @jon_chen this has been asked for by customers for years. I'm sure there is more than just the 1 Idea I linked to for it, here is another one to combine likes... Can get this get in front of the proo...

Thanks Richard, I had figured it out shortly after posting this to you thanks to Kurt Jones in a separate thread. Forgot to come back here to say no need. Have a good one!

@Kurt_Jones wait I got it! I had forgotten to repeat the other 2 rows. This did it:EXISTS:2:$$OBJCODE=DOCUEXISTS:2:currentVersionID=FIELD:documentVersionIDEXISTS:2:DE:project:Region - DX Campaign Ops=APACEXISTS:2:DE:project:Region - DX Campaign Ops_Mod=inSo turns out it was putting "DE" before "proj...

So frustrating I know this must work somehow. No cigar, I keep getting "An error has occurred and we are working to resolve the issue. To continue with your work, try refreshing this browser page." when I add that filter set to my report.I tried:EXISTS:2:DE:project:Region - Campaign Ops=AmericasEXIS...

Hi Kurt, I used this to filter in only Current projects, which works:EXISTS:1:$$OBJCODE=DOCUEXISTS:1:currentVersionID=FIELD:documentVersionIDEXISTS:1:project:status=CUREXISTS:1:project:status_Mod=inSo figured I'd use the same logic to also filter in only projects in Americas region, for example but ...

Hi Richard! Found this thread looking for help on custom field filters on a proof approval report. Can you help me translate this into a filter? I can do the column text mode just fine but when I try to use EXISTS text mode in filters I can't crack it. I want to use this Region custom form field (pr...

Hi @Kurt_Jones this thread is a wealth of info and I remember you sharing these reports in that past and I do use some of the columns. Hoping you can help with a proof approval report filter that I just can't crack. I have a custom form field for regions and I have a different proof approval report ...