I have sharepoint 2013 I have list with two columns. First column is STATUS (choice type = not startet, in progression, finish) Second column is FINISH_DATE (date type). I need automatic fill. When i choose FINISH in Status column the system should automatic fill FINISH_DATE with today's date. I have no idea how to handle this problem.

1 Answer 1


Not sure if this is what you are looking for but this should be a simple workflow that triggers on edit. Open up SharePoint Designer and create a new workflow on the list. This should be the logic:

If Status equals FINISH
  Set FINISH_DATE to Today
  • thank you, this formula is exactly what I want, but I have problem with syntax in sharepoint (syntax error, function not supported)
    – DOD
    Nov 20, 2017 at 10:52
  • This would be a workflow, not a calculated column
    – Mike
    Nov 20, 2017 at 14:15

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.