ACQ: Replaced Contract Valid_FY18

This is a new category

Form: Major IT Business Case (BY2018)

Form Tab: Acquisition/Contract Strategy (BY2018)

Dynamic List Scorecard: ACQ: Existing Contract Replacement

Category: ACQ: Replaced Contract Valid_FY18

Data Type: Indicator

Javascript:

var contractid = getCell("ACQ: Planned Procurement ID (Manual)").Value;

var piid = getCell("PIID").Value;

var refpiid = getCell("ACQ: Referenced PIID").Value;

var status = getCell("ACQ: Contract Status").Value;

if(status != null){

if(contractid == null){return red;}

if(piid == null){return red;}

if(refpiid == null){return red;}

else{return green;}

}