I have an Employee Prospects* list that consists of many columns, but the two columns that are relevant to my question are: "Made Offer" (values are either yes or no) and "Business Area" (consists of 6 job types). I have another table that lists the number of available positions open by the 6 job types.
Each time the column "Made Offer" equals "yes" I need the number of available positions in the other list to decrement based on the business area. Is this possible to do with using a workflow?
- I am running on a Standard 2013 SharePoint License.