CODEWITHSUNDEEP
archerrsa-archer-grc
PokéDev
PokéDev

Reputation: 163

Archer GRC Calculation based on three fields

enter image description here

    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"

Upvotes: 0

Views: 535

Answers (1)

Tanveer Shaikh
Tanveer Shaikh

Reputation: 1688

    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!

Upvotes: 1

Related Questions