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)

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Paul Newcome

Try an IF statement...

=IF([Finish Date]@row <> "", SUM([Date of import/Delivery]4 - [Date received by INFX]4))

Louis Carrillo

Unparseable

i thought an IF statement could work but wasn't sure if i was formatting it incorrectly.

not sure whether not blank or value present would be better argument?

thanks

Paul Newcome

Can you copy/paste the formula from the sheet directly to here? What is the exact name of your finish date column?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.