# Why Are CaseMilestone Fields / Salesforce Formulas Not Updating?

CaseMilestone is an example of a Salesforce table that contains formula columns whose values may change even when other fields of a CaseMilestone record do not change. In fact, the CaseMilestone table contains both types of Salesforce formula columns difficult to include in an incremental backup:

1. A formula field whose value changes when the value in another record (in the same table or a different table) changes.
2. A formula field whose value is computed using the current date or time.

To identify Salesforce formulas in a Salesforce standard table look for non-reference field columns where the API does not have update access. Knowing whether a formula field value will change even when the corresponding fields in the record do not change is a bit more difficult.

## Fixing The Problem

The solution to this problem is to periodically run the [CopyStorm/Medic Refresh Columns](/reference/copystorm-medic/refresh-columns.md) tool to bring the problem formula columns back in sync with Salesforce.

## Problem Salesforce Formula Fields

The following table lists Salesforce defined formula fields that are known to have the issue described above:

| Table         | Problem Formula Fields                                |
| ------------- | ----------------------------------------------------- |
| CaseMilestone | <ul><li>IsViolated</li><li>ElapsedTimeIn.\*</li></ul> |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.capstorm.com/frequently-asked-questions/usage/why-are-casemilestone-fields-and-others-not-updating.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.