Hello @Doug Den Hoed‚ and @Tracy Parmeter‚ - I'm in a similar position, so I was pleased to read these posts. Our current Workfront production environment is set up for our Marketing Department and includes request queues, custom forms, templates, projects, layouts, dashboard, reports, etc.Recently...

Perfect solution, @Doug Den Hoed‚! Once again, thank you for your help. My report is functioning as intended now. 

I have a calculated field on a custom form called "CalcPriScore" That field is a sorted column on a report. It is string though, rather than numerical so it isn't sorting properly. How can that column to be sorted numerically instead? I have this text mode for the CalcPriScore (Prioritization Score...

OMG @Anthony Imgrund‚ ! Thank you. I swear I tried that, but obviously had something wrong. It's showing exactly how I want now!!

On a project report, I included these columns:Last Note: Note TextLast Note: Entry Dateand it appears that Last Note: Owner ID is the person that entered the last noteCan I get to the name of the person that entered the last note, rather than their ID?

That is very intriguing, @Doug Den Hoed‚! I'm interested to see if we can make this happen. I'll reply to your email address with mine. Looking forward to hearing from you. Thanks!

Thanks, Anthony! To make sure I'm following you about not being able to sort by a collection... is this a collection because of my multiple IF statements (Live QA Review, Immediate Live QA Review, etc), or is it a collection simply because I have even one IF statement and/or "listmethod=nested(tasks...

The project report includes a “Due On” column, which is the Project, Planned Completion Date.My text mode column is called “Plnd Live Testing,” which shows a date for tasks with specific names.Both the task and project appear to have a Field Name of plannedCompletionDate. I want to sort first by Pln...

Thank you, @Richard Leek‚!

I have a custom form with a calculated field, to show the average of the overall effort. "Overall Effort Average"The custom form calculation is: AVERAGE(UX Effort,Design Effort,Dev Effort) My report includes this calculated field as a column,I would like to show whole numbers in my report, or perhap...