Forum Discussion

Qrew Trainee

Re: Nested IF Statement to Populate Field

What I'm trying to say (but doing it poorly) is:

if the first condition is meet, then enter "Yes" in the field,
- If not look at today's date,
  - If today's date < the Due Date or if the Due Date IsNull enter "No"

I hope this makes more since.

------------------------------
Terri Wells
------------------------------

8 Replies

MarkShnier__You
Qrew Legend
5 years ago
Ok. Just boarded a plane. If there is Wifi I will post back soon.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  Yay for airplane Wifi,
  Try this
  
  If(
  [Proposal Received 2B Alight]<=[PWO Proposal Due Date],"Yes",
  
  Today()<[PWO Proposal Due Date] and IsNull([Proposal Received 2B Alight]) ,"Yes","No")
  
  // I'm not sure what order you want the tests as Quick Base will keep processing until it hits the first true result. So you might need to flip the test sequence.
  
  Note that with Quick Base IF formulas it is rare that you need to nest your IFs. YOU typically, open with the IF and then stack the tests vertically for readability.
  
  EDITED Above to remove with an extra bracket
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - TerriWells
    Qrew Trainee
    5 years ago
    That worked. Thank you!
    
    ------------------------------
    Terri Wells
    ------------------------------