MICHAELSARGENT
2 years agoQrew Cadet
Formula - Text Field Issue
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
------------------------------
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
------------------------------