The client has a field in the Account, which is a roll up summary (sum) of a formula column in Opportunity. Let's call the formula field in Opportunity oppFormulaField.
The formula field is not visible in roll up, so the customer created another column in Opportunity (let's call it oppField2) and with a workflow try to duplicate the value of oppFormulaField.
Since the original Opportunity field formula (oppFormulaField) has time based formula, the value changes over time, but the changes don't get reflected in the workflow process and oppField2 doesn't have get updated over time.
They are suggesting to write an apex to daily copy the value of oppFormulaField to oppField2. But the whole thing seems to me so much broken. It's more like putting band aids all over the place.
Is what they are suggesting a good way to deal with roll up summary and formula fields or there are better reliable solutions for aggregation over a time based formula field in another object?
Here is the formula field:
IF((End_Date__c >= TODAY() && CloseDate <= TODAY()),"Yes", "No")