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...

Formulas and functions

MarkShnier__You

Qrew Legend

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

Qrew Member

3 years ago

It worked! Thank you so much for your help.

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

Forum Discussion

Formula two fields two comparisons