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
------------------------------
JenniferPeterso's avatar
JenniferPeterso
Qrew Member
6 years ago
Awesome, I wasn't sure I could stack them like that. Thank you

------------------------------
Jennifer Peterson
------------------------------