Forum Discussion
MarkShnier__You
Qrew Legend
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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MarkShnier__You
5 years agoQrew Legend
Yay for airplane Wifi,
Try this
// 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
------------------------------
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
------------------------------
- TerriWells5 years agoQrew TraineeThat worked. Thank you!
------------------------------
Terri Wells
------------------------------- TerriWells5 years agoQrew TraineeThe formula above works great when the data is entered initially. The issue I'm having now, if the date fields change the "Yes" / "No" field keeps the original value. How do I get this field to update every time one of the dates change?
As always, thanks for your help.
------------------------------
Terri Wells
------------------------------- AustinK5 years agoQrew CommanderAs Mark said you may need to flip the formula around because if the first line "[Proposal Received 2B Alight]<=[PWO Proposal Due Date]" is true it will always be Yes in the box even if the second condition changes.
Which dates are changing and what are you expecting to happen when it changes?