help with If function


I have the following if function (IF([Audit Start Date]3, ([Audit End Date]3 + 7), "Audit to be Scheduled") and I get Invalid data type.  

the formula works when there is no date in column.  However, formula does not work when there is a date in column.

I dont know what else to try.  This formula works in excel...



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!