Thanks--I didn't know about this setting, but it does the reverse of what I want.  The setting adjusts the actual completion date to match the planned completion date.  What we need is for the actual completion date to remain 'Now' when the task is completed but for the planned completion date to ch...

Try this to see if it works:WEEKDAYDIFF(CLEARTIME({plannedCompletionDate}), {DE:Report Delivery Date})I would think that WEEKDAYDIFF should give you smaller values than DATEDIFF if the dates don't match. 

You are correct--I've run into issues when comparing native WF dates to custom field dates.  The dates themselves can be the same, but the presence of a timestamp in the native date field causes a comparison to flag the dates as being different.In your custom calculated field, you can use the CLEART...

Hi All, Most of our projects are launched from templates, where we have set durations for each task.  Because of the high volume of work and competing priorities for our department, it's not uncommon for folks to complete their tasks earlier than or later than the task planned completion date.  We l...

Cross-project predecessors are a necessity for us for certain product lines. A few years ago, we split the development of our core annual learning products into front-end and back-end projects.  The front-end projects (or modules) contain content development tasks (writing, copyediting, etc.), and e...

I'm not seeing a way to reference the baseline in a custom form calculated field--the baseline object is not listed in the calculation editor for a task-based custom form (and I don't see a baseline-task-based custom form option). It is possible to build a baseline task report and include a comparis...

Our department handles a mixture of project types, and they get into WF through various methods:Our creative services work and other ad hoc jobs are submitted through a request queue; a portion of our Ops team then converts the requests to projects, assigns users to job roles, etc. Large-scale learn...

Yes, that's what we've had to use in the custom calculated field.  You could also use the function in the report itself, but then you lose the ability to base conditional formatting off of it.

I'd love if there were an option in the report builder to just use dates.  You have the option to choose the format (e.g., short date, short date with time, etc.), but the timestamp remains even if only the date is showing.  I've found this to be problematic when attempting to conditionally format a...

Hi Matthew, Are you tied to a project report, or can you have a task report (with some project info pulled in)?If it's the latter, you might be able to filter your task report to show tasks where: (1) Percent complete is less than 100; (2) Can start is True; and (3) Number of children is 0. You coul...