Auto formula Sum is generating a 0 when no data is present yet


I have a column with an autogenerated formula looking at turnaround time. Essential day completion minus day start. Somethings are finished the day of and have a turnaround time of 0 days which is great for us, however, for rows that do not have a finish date yet it is auto generating a 0 instead of what should be a blank. Any way to add this into the formula. The big issues is that this skews the data as multiple 0's are now present lowering the average turnaround time.

This is the formula right now

=SUM([Date of import/Delivery]4 - [Date received by INFX]4)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!