Forum Discussion

BrandonBishop's avatar
BrandonBishop
Qrew Member
4 years ago

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...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
In 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
------------------------------
BrandonBishop's avatar
BrandonBishop
Qrew Member
4 years ago
Thanks Mark! Worked like a charm.

Brandon

------------------------------
Brandon Bishop
------------------------------