You need to sign in to do that
Don't have an account?
Scott Chambers 2
Making one field equal to another through Workflow Rule
I've created two custom fields for opportunities that are "Revenue Per Order" and "Yearly Revenue."
I'd like to create a workflow that says "If Revenue Per Order" does not equal "Amount", modify Amount to equal Revenue Per Order. Revenue per Order is required, while Amount is not. I believe I've gotten the criteria correct, but cannot seem to find the correct immediate actions.
Any help would be greatly appreciated.
I'd like to create a workflow that says "If Revenue Per Order" does not equal "Amount", modify Amount to equal Revenue Per Order. Revenue per Order is required, while Amount is not. I believe I've gotten the criteria correct, but cannot seem to find the correct immediate actions.
Any help would be greatly appreciated.
- Create a workflow rule on Opportunity object.
- Set Rule Criteria : Amount != Revenue Per Order (Use formula to define this criteria)
- Set Evaluation Criteria as per your requirement: Evaluate the rule when a record is created | Evaluate the rule when a record is edited | Evaluate the rule when a record is edited to subsequently meet the criteria.
- Then add an immediate action as Field Update.
- Select the field to update as "Amount". Then select "Use a formula to set the new value".
- In formula editor, put "Revenue Per Order" field. Click Save and activate workflow rule.
If this helps, please mark it as answer.Regards,
Neha