基于三个字段的弓箭手GRC计算

Question

​

​

    IF [Chemical Incident Awareness Required] = VALUEOF([Chemical Incident Awareness Required],"No")
    [Chemical Incident Awareness Status] = VALUEOF([Chemical Incident Awareness Status],"Pending")

我需要帮助创建一个计算，将字段化学事故感知状态(一个值列表)设置为“待定”，其基础是是否需要化学品事故感知(另一个值列表字段)为“否”。

此外，如果已完成的化学品事故识别日期是任何有效值，则将化学品事故意识状态设置为“已完成”

Answer 1

    IF(
    NOT(ISEMPTY([Chemical Incident Awareness Date Completed])),
        VALUEOF([Chemical Incident Awareness Status],"Completed"), IF(
    [Chemical Incident Awareness Required] = VALUEOF([Chemical Incident Awareness Required],"No"),
        VALUEOF([Chemical Incident Awareness Status],"Pending")
    )
    )

希望这能有所帮助！