Skip to main content
Question

Formula two fields two comparisons

  • July 19, 2022
  • 0 replies
  • 41 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement