Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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.
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.