Forum Discussion

JenniferPeterso's avatar
JenniferPeterso
Qrew Member
6 years ago

Multiple Criteria for 1 Line in a Case Statement

I have a series of Case statements that are used to calculate a due date, based on a large number of contract terms (ex. 6 mos end of FW / 24 mos 1st pymt, 6 mos end of FW / 30 mos from 1st pymt). The...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You can have an IF statement within the Case

 for example

"90 days from end of FW / 30 days before MSO Deadline" , IF(condition is true,[do this], [else do that]),


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ThomasLaMotte's avatar
ThomasLaMotte
Qrew Member
6 years ago
Is the same thing true with Case statements within Case statements? Or Case statements within If statements?

------------------------------
Thomas LaMotte
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Yes

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------