AnsweredAssumed Answered

Prevent Calculated Date Field from Updating on Each Record Save

Question asked by Erica Rotermann on Dec 14, 2017
Latest reply on Dec 15, 2017 by Francesca Shiekh

I have a simple formula built to generate today's date when an Opp is updated to "Closed Won".   The formula checks for a 'behind the scenes' checkbox, which is triggered on the relevant update to the sales stage, and displays the date if the box is checked.  We are running into an issue where the date is updated each time any field is updated within the Opportunity record.  I am looking for something to add to my formula that will prevent the date from updating more than once.  We are running Sugar Enterprise 7.7 - any help or suggestions would be appreciated!!