If you haven't already, you may want to check out this page: Overview of calculated data expressions.

Thanks @NicholeVargas, I think you're right that it can't be in-line edited. Bulk editing via checkbox might save a little time though, I'll have to play around with that.

great idea!

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...