Nested IF Statement to Populate Field
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(IsNul...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I'm trying to test for the following:
------------------------------
Terri Wells
------------------------------
- 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
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
------------------------------- 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"
- If not look at today's date,
I hope this makes more since.
------------------------------
Terri Wells
------------------------------- MarkShnier__YouOk. 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
------------------------------
- if the first condition is meet, then enter "Yes" in the field,