Hello, I am trying to write a formula with the following logic:
- check if a particular word (ie “mtd_sk”) is a selected value in the choice field named “Certs_Disa”.
- if the above condition is true, return the field value “EffectiveDt” (a date value) in the column.
The below code is the formula I wrote, but it is not working… any thoughts?
for cert in $Certs_Disa: if cert.lower == "mtd_sk": return $EffectiveDt