Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
Try this version
If(
IsNull([Started]) and Today() < [Start], "Past Start date but not started,
[Active Dif Calc]>=7,"LT7",
[Active Dif Calc]>=1,"LT1",
[Active Dif Calc]=0, "N/A")
You have asked for the result to be "N/A" if the date that the job was started was equal to the date the job was supposed to start, and then also asked to have it read E1 if the job was started a few hours early but that could be on the same day as it was supposed to start, so that would calculate to "N/A".
ie the N/A and E1 logic you have asked for does not make sense to me. You may have to illustrate with an example.
If(
IsNull([Started]) and Today() < [Start], "Past Start date but not started,
[Active Dif Calc]>=7,"LT7",
[Active Dif Calc]>=1,"LT1",
[Active Dif Calc]=0, "N/A")
You have asked for the result to be "N/A" if the date that the job was started was equal to the date the job was supposed to start, and then also asked to have it read E1 if the job was started a few hours early but that could be on the same day as it was supposed to start, so that would calculate to "N/A".
ie the N/A and E1 logic you have asked for does not make sense to me. You may have to illustrate with an example.
- KatrinaE6 years agoQrew CadetRight now, it's showing these results LT7 shows up if a number is greater than 7
- QuickBaseCoachD6 years agoQrew CaptainIf(
IsNull([Started]) and Today() < [Start], "Past Start date but not started,
[Active Dif Calc] <7 and [Active Dif Calc]>1,"LT7",
[started]-[start] > hours(0) and [started]-[start] < Hours(24), "L1",
[Active Dif Calc]=0, "N/A") - KatrinaE6 years agoQrew CadetFor this part of the formula If(
IsNull([Started]) and Today() < [Start], the "<" won't work because the fields are date/time - QuickBaseCoachD6 years agoQrew CaptainIsNull([Started]) and Today() < ToDate([Start]),
- KatrinaE6 years agoQrew CadetThis worked the way I wanted it to show. Thank you!!!!!!
- QuickBaseCoachD6 years agoQrew CaptainGreat,
Thx for letting me know.