Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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]
[Start Date]
[Start]
[Started]
KatrinaE
7 years agoQrew Cadet
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
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