Forum Discussion
QuickBaseCoachD
7 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.
- KatrinaE7 years agoQrew CadetRight now, it's showing these results LT7 shows up if a number is greater than 7
- QuickBaseCoachD7 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") - KatrinaE7 years agoQrew CadetFor this part of the formula If(
IsNull([Started]) and Today() < [Start], the "<" won't work because the fields are date/time - QuickBaseCoachD7 years agoQrew CaptainIsNull([Started]) and Today() < ToDate([Start]),
- KatrinaE7 years agoQrew CadetThis worked the way I wanted it to show. Thank you!!!!!!
- QuickBaseCoachD7 years agoQrew CaptainGreat,
Thx for letting me know.