AnsweredAssumed Answered

Result formula

Question asked by ToddCarlson on Sep 19, 2013
Latest reply on Sep 19, 2013 by ToddCarlson


Result formula


     I can't seem to figure out how to make the Due Date field empty until Production Date is populated.  Here is what I have:

     If (( # of Specialties < 1 ) and not IsEmpty ( Production Date ) ;Production Date + 14; Production Date +30)

     The Due Date shouldn't have a date in it if Production Date is empty, then it should use # of Specialties < 1 to produce the result.  I have tried so many variations even using similar formulas that work the same but I can't figure it out.

     The Due Date field is a calculation; the Production Date field is a date field; and # of Specialties field is a number field.

     Thank you!