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", ...
Forum Discussion
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
MarkShnier__You
Qrew Legend
Qrew LegendI reviewed your formula and it looks valid to me You do not need to have nested IFs like Excel.
Is there any chance that any of these fields are involved in a circular relationship, a self referential relationship?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Is there any chance that any of these fields are involved in a circular relationship, a self referential relationship?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------