We have project templates that build out with all of our possible shipments (six) as tasks that are lag-dependent upon the completion date until the Due Date is manually set.
For project-level reporting, we have relation summary custom fields (two) that are tied to the two shipments that we consider 'system'. One of these will exist in every project but both is optional.
When one of these two shipments is not in the project's order, we delete the task. Unfortunately, that is breaking the relationship and Clarizen is setting the custom field value to '12/30/99'.
I wanted to 'fix' this by setting up a scheduled workflow rule that would look for any 12/30/99 dates and change them to Null but the fields are not available under the Update Field action, I'm guessing because they are still seen as relational fields.
Is there a way to update a relation summary custom field if the related item no longer exists?