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
I 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
------------------------------
------------------------------
MICHAEL SARGENT
------------------------------
