I am looking for a solution workflow to update fields when it matches two different columns.
Below is my scenario:
I have a list with fields: full name and id number for which each new items goes through approval. Once approved the status field is set as 1. When a new item is added, and if it matches both full name and id number, then the workflow should automatically update each items status field with 2 and so forth until it reaches 5.
Basically, this is a merit system. It has a merit column and the type of merit column. There is 5 different merits types, three based on departments: HR, IT, and BD, and two after all three sector merits are received: Professional, and Expert. When the merit column is either HR, IT, or BD, the merit column should display either of the selected merit types. The merit column must append new merit types received. Once all 3 sectoral merit types are received, on the 4th update, the merit column should say Professional, and on the 5th update, the merit column should say Expert.
Any help is appreciated!