Managing Testing with Automation Waterfall Notification and Showing Status with RYGB Balls
I have spent some time looking for solutions to my specific need but have been unsuccessful to find anything that fits right, although there were lots of good suggestions that I tried (and couldn't make it work).
We are migrating servers from one location to another and we have multiple IT groups that need to test the servers once they are handed over to us. We would like to have a waterfall for hand off between the groups. The testers vary by server (row) and some groups won't test the server at all.
In the example below the testing groups are in pairs with the names first and the testing status on the right for that group
Row 1 - Only the Hud Data Mgmt team will test, once they put the status to Complete, nobody else needs to be notified, but it would be great for the Hud Test Plan Complete box to assess the status in each of the columns and set itself to checked if done.
Row 2, there are 2 groups of testers; When Henry and KR have set their status to complete, DCiskie needs to be notified. Once she sets her status to complete the Hud test plan complete box should turn to checked
If there is a tester, than a contact will be specified and they will use the status's as follows. No tester for that group will use N/A
Secondly, we would like to reflect the overall testing status across all 4 groups in one RYGB column. I can get a single column evaluation formula to work, but have been unsuccessful trying to apply a between the columns type of formula.
If Issue in any column - Yellow
If N/A in all columns - Blue
If In Progress in any column - Green
If complete in all columns - Blue
If Hud Test Plan Complete is checked - Blue
Help Article Resources
Check out the Formula Handbook template!