We want a field that comes back as True/False or Yes/No when the financials were approved on a deal. However we have to make sure no changes were made to the deal once the financial approved property is known. So if the Start date, duration, or Deal type changes after the financials were uploaded the user should not be allowed to mark the deal as closed won. Can we make a calculated property that reads If start date, duration, Deal was updated before Financials Property was updated then mark as true, if either of these were updated after the financials mark the property as false(then this field will be used as the required field for closing a deal)
I understand what you are trying to achieve and I believe you can do this with a workflow. I would do it like this:
1. Create custom property yes/no format to indicate whether any of the required properties were changed.
2. Trigger would be start date, duration or deal type is known.
3. Branch in 2 - start date or duration or deal type changed after financials were approved / none met
4. Set property value to Yes for branch 1 - Set property value to No if none met branch
I’m not also sure how financials were uploaded would be recorded - perhaps another custom property?
To perform this calculation, you would have to use date stamps (create date property + use workflows to set the date property to the current date when property is updated). Once you have these dates, you can use them in your calculation property.