Archer GRC Calculation based on three fields

Question

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

I need help creating a calculation where I set the field Chemical Incident Awareness Status (a value list) to "Pending" based on if Chemical Incident Awareness Required (another value list field) is "No".

Also if Chemical Incident Awareness Date Completed is any valid value set Chemical Incident Awareness Status to "Completed"

score 1 · Accepted Answer · edited Sep 15 '16 at 14:53

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")
    )
    )

Hope this helps!

edited Sep 15 '16 at 14:53

PokéDev

163
4
14

answered Sep 15 '16 at 05:25

Tanveer Shaikh

1,678
14
27

Archer GRC Calculation based on three fields

1 Answers1