It would depend on what date you're looking at (e.g. Actual Completion Date, Planned Completion Date, etc.) but here's an example of filtering tasks where the Actual Completion Date is >= 12 months ago:Actual Completion Date gteIf you were looking at Text Mode, the code would look like this:actualCo...

Is there a way to edit a project's Schedule Mode from a report?There are times when I'd like to switch the Schedule Mode of several planned projects from "Start Date" to "Completion Date". It's a lot of clicking to have to navigate to each project individually and switch the Schedule Mode. I've crea...

@ArthurChalamet Can you pull in the Handoff date to the report and see what the date is? My formula doesn't look at the Planned Completion Date (Due On), it looks at the Handoff Date.

Amazing! Thank you!

Could you give an example for one of the day columns, as to how you're comparing the task date to the day of the week? I've been playing around with some combinations of DAYOFWEEK, and TODAY(), but my formula is getting out of hand and I feel like there's probably something simplier I'm overlooking.

@KellieGardner I really love this M-F view! Thanks for the idea!

You probably want to look at the task's handoffDate rather than the Planned Start Date / Planned End Date. That's the date that the predecessor task completed and was "handed off" to the current task. So if you add the current task's Duration to the HandoffDate, you get a fairer due date for the ass...

I recreated your DE:SLA Date in my sandbox environment, gave it a try, and it worked for me. My main difference is that on the "SLA Met" calculation, I added a condition to look at the project status and only check the DE:SLA Date if the Project Status was Complete.Here's the code I used.IF(CONTAINS...

Ah, I see. I think you want to use 9600 instead of 160. It's my understanding that most time-related calculations in Workfront are done in minutes, not hours (even though the field says planned "hours"). So, 60 minutes * 160 hours = 9600.Try this:aggregator.displayformat=valaggregator.function=SUMag...

What does the 160 represent?