Nested IF Statement with Dates
Hello, We are looking to write a formula which returns text ("PSC" or "Protest") based on a few different conditions. Can anyone help to translate this into a QuickBase formula? IF([Estimated Li...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIn Quickbase, unlike Excel we don't have to "nest" our IFs.
We can also space out of formula for readability
IF(
[Estimated Liquidation Date]>TODAY()+DAYS(14),"PSC",
[Estimated Liquidation Date]<=TODAY()+DAYS(180)
AND
[Estimated Liquidation Date]>=TODAY(),"Protest",
"TBD")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
We can also space out of formula for readability
IF(
[Estimated Liquidation Date]>TODAY()+DAYS(14),"PSC",
[Estimated Liquidation Date]<=TODAY()+DAYS(180)
AND
[Estimated Liquidation Date]>=TODAY(),"Protest",
"TBD")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks Mark! Worked like a charm.
Brandon
------------------------------
Brandon Bishop
------------------------------
