MICHAELSARGENTQrew Cadet3 years agoFormula - Text Field IssueFormula - 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", ...Show More
MarceloBenavideQrew Cadet3 years agoHello. I think it is necessary have if nested. When the condition is false you need write if(....Similar to excel ifFormulaMarcelo Benavides Torres
Related ContentAccess IssuesFormula Date FieldDate Field FormulaChild Table - Grid Edit IssuesEmbed hyperlink in Formula Rich Text field