I am trying to create an email reminder automation on one of our project schedules. We want the alert to go out 10 days before the line is set to be due (Finish Date Column). I created a date column to generate the reminder date (for the automation to use) by subtracting 10d from the finish date column. Some lines in this schedule are linked to predecessors in other sheets which means they start off blank until that predecessor is completed. When I subtract days from an empty cell I get a #DATE EXPECTED error which is just super annoying to look at constantly. Instead, it should just return a "-" or just be blank. =IFERROR will not fix this error message (I tried). Whats the workaround for this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!