I reached out to the Product team on this, but haven't heard back yet. This could also be a good question to ask in the Data Connect session we have scheduled for Thursday, May 29 because the Product Manager over that is also responsible for Canvas Dashboards. 

@DeepaMa1 Are these custom fields set up as date, number, or text fields? Asking because if you are wanting to use a subtraction calculation, they would need to be set up as number fields. If they are date fields, are you wanting to look at the date difference between the two? Any additional context...

Adding a reply here so the following text mode filter exists in the Experience League Community (and search) for those interested in project template cleanup.EXISTS:A:$$EXISTSMOD=NOTEXISTS EXISTS:A:$$OBJCODE=TASK EXISTS:A:entryDate=$$TODAY-1y EXISTS:A:entryDate_Mod=gte EXISTS:A:templateTask:template...

@Beth_Dawson Looks like @Nijs_Gold_23 offered a solution below, which I'd also recommend! To just add on, whenever you are wanting to pull in multiple Workfront objects to a report (ex: both tasks and projects), I recommend starting off with the object that has the 1:1 relationship, which in this ca...

@AlyssaTrainor New videos/tutorials for Workfront Planning recently came out, so wanted to share!Adding Planning to your instance (License plans and such)Creating a Workspace (Getting started with the foundation for Planning)Create and Manage a Record TypeCreate and Manage Table Views

@KellieGardner I reached out to the Product Manager for clarification on this! I'm also not able to compare 2 fields in a filter using the FIELD:ID option in text mode, so let me try and get more information. 

@JHulet An Hour Report only pulls in logged time, so if you are looking for tasks that have 0 actual hours, I would expect zero results. You may be better off running a Task Report that filters for Planned Hours > Greater Than > 0H and Actual Hours > Equal > 0H.

There is also the option of comparing two fields using a filter, so that you don't have to use conditional formatting - just an idea. See Tip #3 from the 10 Text Mode Tips workshopYou can download the slide deck from that link and watch the on-demand recording (tip #3 starts at the 21-minute mark)

The field in the video, User First Assigned, was a calculated custom field so if you want to follow the same format, what you'll do is:Go to your request custom form Add a new calculated custom field (Format = Date). Click Apply. This will create your field in the database. Go back to edit this cust...

@JennaQu The Adobe offices were closed on Thursday and Friday for Thanksgiving so you should receive a response back early this week!