Periodic (Nightly) Recalculation of Custom Expressions | Community
Skip to main content
Level 2
March 17, 2021
New

Periodic (Nightly) Recalculation of Custom Expressions

  • March 17, 2021
  • 0 replies
  • 329 views

We have options built into WF to automatically update project timelines each night.

It would be great to have a similar facility to update all calculated custom expressions or perhaps subsets thereof.

We use a number of calculated fields that compare the current date to task dates and baseline dates. We report on them and conditionally format based on values.

A possibility is to put the custom expressions in report columns. These always produce an updated result when the report is run. However you can't do condition formatting on an expression. Hence the need to put the expression on tasks, report on the field value and conditionally format based on the value.

Anyone else like this idea?