AnsweredAssumed Answered

Going To Another Field If Blank

Question asked by CraigBarnes on Aug 28, 2011
Latest reply on Aug 28, 2011 by CraigBarnes


Going To Another Field If Blank


I have 15 fields for alculating times, each building on the previous and that works good. But, all of the fields may not be used, sometimes maybe on the first 4 or 6 fields. How would I make the calculation stop if the previous field was empty and go to a specified field?

An example would be the first 5 are used and have times in them, the 5th field is blank so the DEP field needs to calculate the time from field 5.

5 Timepoints

The calculation that I have written works for the current field, but not on the follwing fields.

7 Timepoints

Thanks for any help and/or comments.