Formula
= m3Options = [
"Signed by CEO"
"Signed by Director"
"Signed by Managing Director"
"Signed by Chairman"
]
c1 = uk_msa_assessed == "Yes"
c2 = m1 == "Yes"
c3 = m2 == "Approved by Board"
c4 = [m3].flat().filter( (v) -> m3Options.includes v).length
statement = [statement].flat()
c5 = isKnown(statement) && (statement.includes "Yes - UK Modern Slavery Act")
c6 = isKnown(statement) && (statement.includes "Yes - Australian Modern Slavery Act")
c7 = isKnown(statement) && (statement.includes "Yes - California Transparency in Supply Chains Act")
if c2 && c3 && c4
if c1 && c5
"Yes"
else if c6 || c7
"Yes - but non-UK statement"
else
"Yes - but statement partially assessed"
else if c5
"No"
else if c6 || c7
"No - but non-UK statement"
else
"Unknown"