Hi Skye, Since I'm sitting here waiting for something to finish processing, I decided to do a quick experiment. I can tell you that with my data 615 worked, but 627 did not….so somewhere in between? FWIW, the reporting snobs of the world tend to have an almost visceral reaction to the use of A...

BTW, attached is a quick sample Excel workbook to show what I'm talking about.

Hi Alex, Honestly, if I were up against this, I'd just create a report with the fields you care about (task report with task name and status and project name…where project is not complete), export it, and throw together a couple of formulas to flag what you care about. If you make a copy of th...

Hi Jaclyn, You might want to check out Melinda Layten's post for a great alternate approach. "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=cc68cd94-ba57-4629-88b2-31b67cc3dcc2&CommunityKey=aaafaff0-5e4e-4e38-8903-f1f990935567&tab=digestviewer#bmcc68cd...

Hi Chris, You might want to look into a Work Item report. This will break out each of the people assigned to a task and show you their completion status on that task. I believe you can then set up your filters in a similar manner to what you have now. Kathy

Hi Dags, I saw something similar a few months ago and after fighting with it for a while, finally decided it was a bug. Fortunately, we were reworking some of our fields at the time, and I just worked around my observations as we set up the new fields. Thus, I never reported it to Workfront. However...

Hi Tim, Adding to what Doug and Melinda have said, it's also worth mentioning there are subtle differences between syntax on custom fields (the ones you set up on a custom form) vs calculated fields in reports. If I'm interpreting correctly, I think you are working on a calculated field in a report?...

Hi Susan, This isn't the least bit elegant, and the performance would probably be unpleasant in a large report, but if you're desperate, I believe the following will work. In a quick test I did where I exported a decent subset of data and compared the results against those of WEEKNUM, everything mat...

Hi Jaclyn! Congratulations on working through this beast! You are SO close. I see a couple of things that I think will fix your problems. First, the field name at the very end (prior to the >730) says "DE:Age" rather than "DE:RTS Age". Lastly, the the character just prior to all your closing parenth...

Hi Randy, You might try the following: displayname=Name+Extlistdelimiter=<br>listmethod=nested(documents).liststextmode=truetype=iteratevalueexpression=CONCAT({name},".",{currentVersion}.{ext})valueformat=HTML It appears they don't save the extension within the Documents collection itself, but inste...