I'm trying to determine if a proposal is late. Below is the formula: If([Proposal Received 2B Alight]<=[PWO Proposal Due Date],"Yes","No") If(ToDays(Today())<[PWO Proposal Due Date])and If(IsNull[[Proposal Received 2B Alight]) ,"Yes","No") The first "If" statement works without any issues, but I get the following syntax error on the second "If" statement: Error: Column: 0 > There are extra characters beyond the end of the formula.I'm a new QuickBase user, and any help would be appreciated.------------------------------Terri Wells------------------------------

That worked. Thank you!------------------------------Terri Wells------------------------------

np to help you, but we need to know what logic you want. To quote the famous Kirk Trachy, "if you can say it we can do it."------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

I'm trying to test for the following: If Date "A" <= Due Date The proposal is on time, enter "Yes" otherwise enter "No" I'm checking for today's date and comparing it to the Due Date If the Due Date is < then today, enter "Yes" otherwise enter "No" If the due date is > today, and the Proposal Received date IsNull, enter "Yes" otherwise enter "No" ------------------------------Terri Wells------------------------------

TerriSorry but your logic is still not clear. There is only one field that we are populating and we can't put both a No and a Yes. Is what you were really saying is that you want to do the first test and if true, you want Yes, else go onto the second test?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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------------------------------

Nested IF Statement to Populate Field

MarkShnier__You
Qrew Legend
6 years ago
np to help you, but we need to know what logic you want. To quote the famous Kirk Trachy, "if you can say it we can do it."

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- TerriWells
  Qrew Trainee
  6 years ago
  I'm trying to test for the following:
  
  If Date "A" <= Due Date
  
  The proposal is on time, enter "Yes" otherwise enter "No"
  
  I'm checking for today's date and comparing it to the Due Date
  
  If the Due Date is < then today, enter "Yes" otherwise enter "No"
  
  If the due date is > today, and the Proposal Received date IsNull, enter "Yes" otherwise enter "No"
  
  ------------------------------
  Terri Wells
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    6 years ago
    Terri
    Sorry but your logic is still not clear. There is only one field that we are populating and we can't put both a No and a Yes.
    
    Is what you were really saying is that you want to do the first test and if true, you want Yes, else go onto the second test?
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Nested IF Statement to Populate Field

Related Content

Nested If formula

Dynamic Rule - Or statement?

formula help "if statement"

Jinja If statement equals field value

Nesting URL API Calls in one Button