Skip to main content
Question

Formula - Text Field Issue

  • December 27, 2022
  • 0 replies
  • 35 views
Formula - Text Code:

If(
Trim([Gate 5 - Results Readout - Governance Status])<>"",[Gate 5 - Results Readout - Governance Status],
Trim([Gov Status Summary Gate 4])<>"Pending","Gate 4 Approved",
Trim([Gate 3 - Final Business Case Approval - Governance Status])<>"",[Gate 3 - Final Business Case Approval - Governance Status],
Trim([Gate 2 - Customer / Frontline - Governance Status])<>"Not Yet Reviewed (Gate 2)",[Gate 2 - Customer / Frontline - Governance Status],
Trim([Gate 1 - Size Dev Impacts - Governance Status])<>"Submitted/Not Yet Review (Gate 1)",[Gate 1 - Size Dev Impacts - Governance Status],
Trim([Gate 0 - Approval to Begin - Governance Status])<>"",[Gate 0 - Approval to Begin - Governance Status],"Submitted, Not Yet Reviewed (Gate 0)")

Issue:

Returning nothing.  I figured at minimum it should return the last text of "Submitted, Not Yet Reviewed (Gate 0)".  But, it's not.  The fields in brackets are multiple choice fields.  What am I doing wrong?

------------------------------
MICHAEL SARGENT
------------------------------
    This topic has been closed for replies.

    MarceloBenavide
    Forum|alt.badge.img+8
    Hello. I think it is necessary have if nested. When the condition is false you need write if(....

    Similar to excel ifFormula

    Marcelo Benavides Torres 


    Terms & ConditionsAccessibility statement