When 'Status' field picklist value changes from Open to Closed, I would like to calculate days on 'Duration' field and update 'WO Date' fields at a time using either workflow or process builder in Salesforce. Any solutions??

  • you can use workflow like criteria should be status open to closed.and update duration field like opened date - today.But if there is any other requirement.@Ajay – Pavan tej Oct 5 '16 at 15:01
  • @Pavan tej I would like to update two fields not single field. – Ajay Oct 5 '16 at 15:07
  • You can add another workflow field update on the same rule.If you are depending the result of another field you should select Re-evaluate check on field update but you select second criteria on workflow rule. – Pavan tej Oct 5 '16 at 15:21

Workflow and Process Builder can both cause multiple actions to be triggered on a single set of criteria, see images for this. Workflow rules configuring actions and considerations. Process Builder documentation.

These actions can include field updates, creating a task sending email alerts and outbound messages.

If there is a dependency on one action for the other action to execute then it may be necessary to add an additional step in Process Builder or a separate Workflow rule.

workflow rule

Process builder

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.