I am new to working with Workflow in Sharepoint designer 2013. I am learning inch by inch and trying to manage a contract library. I want to set a workflow with the following algorithm (things in quote "text" means this is a column title). How can I achieve this?
If "Expiration Date" is less than 1 year but more than 190 days AND "Current Status" is not 'Active' *// 'Active' is a drop-down choice in "Current Status" column //* Then trigger this workflow: 1. send email alert to stakeholder [I will add the email content] ELSE If "Expiration Date" is less than 190 days away AND "Current Status" is not 'Active' 1. Send a reminder email alert 2. Then wait 15 days to loop this alert if the "Expiration Date" is not more than 190 days OR "Current Status" is not "Cancelled" Transition To End workflow