Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Periodic (Nightly) Recalculation of Custom Expressions

Avatar

Level 2

16-03-2021

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?