Forum Discussion

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

      Brandon

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