Forum Discussion

AlexanderKouzmi's avatar
AlexanderKouzmi
Qrew Member
3 years ago

Formula two fields two comparisons

Hello All,

I've managed to get to this point 

Case(true,
ToDays(Today()-[Class Start Date])<35, "In Training",
ToDays(Today()-[Class Start Date])>=35 and ToDays(Today()-[Class Start Date])<77, "Supervised",
ToDays(Today()-[Class Start Date])>=77, "Production",
"Hasn't Started")

The complete logic that I need is

If [Program Assignment] = "Brokerage" then
Case(true,
ToDays(Today()-[Class Start Date])<35, "In Training",
ToDays(Today()-[Class Start Date])>=35 and ToDays(Today()-[Class Start Date])<77, "Supervised",
ToDays(Today()-[Class Start Date])>=77, "Production",
"Hasn't Started")

If[Program Assignment] = "Acquisition" then
Case(true,
ToDays(Today()-[Class Start Date])<35, "In Training",
ToDays(Today()-[Class Start Date])>=35, "Production",
"Hasn't Started")

Is it something possible to achieve?
Thank You

------------------------------
Alexander Kouzmine
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    try this
    var text BrokerageResult = 
    If [Program Assignment] = "Brokerage" then
    Case(true,
    ToDays(Today()-[Class Start Date])<35, "In Training",
    ToDays(Today()-[Class Start Date])>=35 and ToDays(Today()-[Class Start Date])<77, "Supervised",
    ToDays(Today()-[Class Start Date])>=77, "Production",
    "Hasn't Started");

    var text AquisitionResult = 

    If[Program Assignment] = "Acquisition" then
    Case(true,
    ToDays(Today()-[Class Start Date])<35, "In Training",
    ToDays(Today()-[Class Start Date])>=35, "Production",
    "Hasn't Started");

    IF
    [Program Assignment]="Brokerage", $BrokerageResult,
    [Program Assignment]="Acquisition", $AcquisitionResult)





    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AlexanderKouzmi's avatar
      AlexanderKouzmi
      Qrew Member
      3 years ago
      It worked! Thank you so much for your help.

      ------------------------------
      Alexander Kouzmine
      ------------------------------