Skip to main content
Question

Nested IF Statement with Dates

  • March 4, 2021
  • 0 replies
  • 52 views
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 Liquidation Date]>TODAY()+DAYS(14),"PSC",IF(AND([Estimated Liquidation Date]<=TODAY()+DAYS(180),[Estimated Liquidation Date]>=TODAY()),"Protest","TBD"))

Thank you!
Brandon

------------------------------
Brandon Bishop
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement