Forum Discussion

KatrinaE's avatar
KatrinaE
Qrew Cadet
7 years ago

Text Field showing different values depending on the calculation

I want a field to show value of "LT1" if it is less than 1 day late than the expected start of the program and other values depending on how many days it is late, I have this formula but it doesn't sh...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Perhaps it is mainly the sequence if the logic checks which is the problem.  But before I can answer we seem to have three fields and I'm not understanding the difference.

[Start Date] 
[Start]
[Started]
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Can you please say the logic that you want in words and then I can convert that to a formula.  Please start with  7 days late and then 1 day late and then on time and then early and then not started to be sure to cover all time periods from late to early.