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
Maybe this is what you want

If(
not IsNull([Started]),"NA",
[Active Dif Calc]>7,"LT7",
[Active Dif Calc]>1,"LT1",
Now()-[Start Date] < Hours(24), "E1")
  • KatrinaE's avatar
    KatrinaE
    Qrew Cadet
    7 years ago
    This just yields a result of �NA�. What I failed to include in this is that I wanted NA if the project has started on time. Right now it only yields NA because the project�s �Started� field is not null even if the project has been started late.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Please post the formula for

    [Active Dif Calc]
  • KatrinaE's avatar
    KatrinaE
    Qrew Cadet
    7 years ago
    (ToDays(ToDate([Started]) - ToDate([Start])))
  • KatrinaE's avatar
    KatrinaE
    Qrew Cadet
    7 years ago
    (ToDays(ToDate([Started]) - ToDate([Start])))