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
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
Qrew Legend
Qrew LegendTerri
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
------------------------------