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
------------------------------
- The formula was actually working perfectly. The gate 2 field was supposed to have a default value. However, we never edited records predating when we changed the field to have a default value. So, many records had nothing in the gate 2 field. And since gate 2 <> "Not Yet Reviewed (Gate 2)", it passed no value to the formula field. Once i figured out the mistake and edited the records to have the default value, et. voila, everything worked. Thank you!
------------------------------
MICHAEL SARGENT
------------------------------
