Hi - you will need to do a calculated field on your task custom form. The first calculation is Project.Name The second calculation is Project.Owner.Name 

I do have an example to show  So first the user picks a region and then based on that select, one of three boxes will appear via display logic. After they select their country, I have a calculated field that pops in the value so that when I'm reporting, I can use that field and get all countries ...

Oh, that is my bad... here you go! IF(ISBLANK(Original Planned Completion Date),Planned Completion Date,Original Planned Completion Date)

It is the custom field. Here is how it looks to me in my instance Is maybe the format not set to Date?

You should be able to use Default Baseline Task for a lot of your reporting. Planned hours, start dates, end dates, etc. As for the calculation, did you do the first step? Create the field, leave the calculation blank, and Save? You need to do that first so that the field is created. Then you can g...

Hi, I'll give you the formula, but you might want to use the baseline to capture this info so you get all info (planned start and completion date, as well as hours). In your setup, you can have your in your project preference an option checked that captures a baseline automatically when you convert ...

Hi Olivia - Here is what I use for the exist filter. EXISTS:1:$$OBJCODE=ASSGNEXISTS:1:assignedToID=$$USER.IDEXISTS:1:assignedToID_Mod=inEXISTS:1:projectID=FIELD:IDEXISTS:1:task:status=CPLEXISTS:1:task:status_Mod=notin Just make sure you do all the project level filters first and then switch to text...

Hi Everyone - for those that have questions or use cases for Calculated Fields, we have a thread going on here: https://one.workfront.com/s/question/0D54X00007Y8fnLSAR/skill-exchange-continue-discussion-on-calculated-field-session Feel free to join us there as well. 

Hi Dan - at the moment, there isn't a way to sort a collection  At my last agency, we worked with @Doug Den Hoed‚ and his Magic Reports tool so that we could get the collection to sort and to have conditional formatting.

Hi Nichole - I have done a report like this to get an average on a single task before. I use it in my template audits. If you grouped by the template task names, you'd at least get the two averages and can add them together. Calculated fields only work on the item they are on OR info on items that...