Section E and F Validation - Update 002

The information for adding the categories Capability Valid_FY18 and System Valid_FY18 have been added at the bottom of the post.  Once added, the validation will work.

The javascript has been updated to:

var capability = getSubItems("Capability ID");

var capstatus = getSubItems("Capability Status");

var infrastructure = getCell("Standard IT Infrastructure & Management Category").Value;

var count = 0;

var need = false;

var need1 = false;

var need2 = false;

var msg = "";

for(var i=0; i<capability.length; i++){

if((capability[i].SubItemType == getValueList("Dynamic List Types", "Capabilities")) && (capability[i].Value != null) && (capstatus[i].Value == getValueList("Active Status", "Active"))){count = count+1;}

}

if((infrastructure == getValueList("Standard Infrastructure & Management Category", "IT Management")) && (count == 0)){need=true;}