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.