I have a worksheet required to check and auto reflect the status based on the number of time the same s/no occurring.
The condition will be:-
1) All the s/no happen in the first time, the status = Open
2) If the s/no repeated the 2nd time, the status = open (1st time) and closed (2nd time).
3) If the s/no repeated a few times, the status changed to open (1st time), in-progress (2nd time onward) and closed (last time)
Need help please!
The condition will be:-
1) All the s/no happen in the first time, the status = Open
2) If the s/no repeated the 2nd time, the status = open (1st time) and closed (2nd time).
3) If the s/no repeated a few times, the status changed to open (1st time), in-progress (2nd time onward) and closed (last time)
Need help please!