I have a sharepoint calculated field that looks at a date and values in two other fields to populate with either a blank or a date.
First criteria: Units > 0
Second criteria: Type = "RDS"
Third criteria: Estimated Ship Date - if that date is blank, display a blank - can't be a zero because I send the data in that field to a SQL data table and if it's a zero the upload fails.
If the Estimated Ship Date is populated, the units are greater than 0 and the type is equal to "RDS" then it takes the Estimated Ship Date minus 28 days.
When I use this formula, I keep getting a zero when the Estimated ship date is blank.
=IF([Units]>0,IF([Type]="RDS",IF([Estimated Ship Date]<>"",[Estimated Ship Date]-28,"")))
I've tried moving the Estimated Ship Date to the beginning of the formula and using ISBLANK but it keeps going to "Technical Issue" which is totally useless.