1

Is it possible that an instance of a workflow can prevent a calculated field from being updated?

My scenario:

SharePoint 2013

Workflow 2010

Calculated field: (=IF([Dt Prox Contato]<Now(),"Old", "Normal" )).

The field receives the correct data, but when the date is exceeded the calculated field is not updated.

Improve this question

1 Answer 1

Reset to default
1

SharePoint updates the value of a calculated field when you save an item OR when you change the calculation in the field setting. A workflow instance can not prevent a calculated field from being updated AFAIK, I've had plenty of instances with workflows running and the calculated fields worked just fine. I guess it might depend on what the workflow is doing.

This post might help: http://sympmarc.com/2009/12/04/how-are-a-sharepoint-lists-calculated-columns-stored-and-rendered/ It explains at which point calculated fields are updated.

Improve this answer
4
  • The workflow sends email when the date exceeded
    – Diego Hillesheim
    Commented Nov 22, 2013 at 13:45
  • Unless you are updating the field in the workflow, I doubt it would have any effect on the calculated field! Why not try removing the workflow instance and check if the calculated field is updated?
    – David
    Commented Nov 22, 2013 at 13:47
  • I've done it and it did not work, I set the workflow only to manual start and check if it will work
    – Diego Hillesheim
    Commented Nov 22, 2013 at 13:48
  • It did not work. But already used this formula before. I will investigate further...
    – Diego Hillesheim
    Commented Nov 22, 2013 at 13:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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