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...
Forum Discussion
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
------------------------------
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
------------------------------
It worked! Thank you so much for your help.
------------------------------
Alexander Kouzmine
------------------------------
------------------------------
Alexander Kouzmine
------------------------------
