I have three document libraries in a document center and I want all three of them to host documents based on their status.
Lib1 should have the daft documents and once the status is changed from draft to completed it should automatically move to Lib2 and then if status is changed there it should move to Lib3.
Firstly I want to make the status column mandate while uploading the documents. How?
Secondly, Is writing a workflow the only possible way to achieve it, if so is there any existing workflow supporting the above operation.