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]
KatrinaE's avatar
KatrinaE
Qrew Cadet
7 years ago
So I want a field that will tell me if a task has been started or not on time.  I want it to yield a result that will say "NA" if Active Dif Calc is equal to 0, and then if Active dif Calc is  less than 7 days but not equal to 1 it will say "L7".  And then if it is less than 1 day, it will say "L1".  Start and Started are both date/time fields.

And if possible, I want to add E1 if the difference between start and started dates are less than 24 hours.

I hope that makes sense.  I've been trying to figure this out but no luck