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
The IF conditions are evaluated in the sequence in your formula. So for starters you need to test for the larger values first and then work your way down to the smaller values.

If(
not IsNull([Started]),"NA",
[Active Dif Calc]>7,"LT7",
[Active Dif Calc]>1,"LT1")

Note that is not necessary to clutter up your formula with extra brackets. It just makes it harder to read.

I do not know what type of field

[Active Dif Calc]

So I don�t know for sure if that formula will work.