Expand my Community achievements bar.

Frozen Calculated Custom Field

Avatar

Level 4
Does anyone have a workaround or a fix for this issue: One of our teams wants to add a calculated custom field on all their projects. The field would be Cycle Time and the calculation is the duration of the project from planned start date to $$TODAY and it subtracts any On Hold time. The problem is that the calculation only updates whenever someone update the custom form or edits the project details. If we don't make any updates to the project for a day or so, the calc will stay frozen since the last update thus showing incorrect information. Is there any way to automate the refresh of calculated custom fields? Or any ideas to easily refresh that calc on a bunch of projects on a routine basis? I believe this idea exchange from 2017 talks about this issue: https://experience.workfront.com/s/idea/0870z000000PSEkAAO/detail Denver Lemont Cardinal Health
2 Replies

Avatar

Community Advisor
Hi Denver, I invite you to consider our "https://store.atappstore.com/product/recalc-helper/" Recalc Helper or "https://store.atappstore.com/product/force-custom-data-double-recalc/" Recalc Parameters solutions to efficiently ensure your calculated parameters are up to date in either an ad-hoc or scheduled manner, respectively. Regards, Doug Doug Den Hoed - AtAppStore

Avatar

Level 2
Hi Denver, This is a manual process for me as well to refresh calculations. I setup a scoring system to weigh priorities from a product management point of view of what items to work on first vs. last which includes items like aging. The days don't auto updated and every few days I have to do a mass edit of all the requests, select the custom form but don't change info, and then hit Save to get it to refresh the points / positions of items (the ones that age longer move up the list). Without having to get a 3rd party solution I haven't found a solution yet. Tim Greek IEHP