Time Spent (DAY)

Hello-

Can you assist me with my formula?

I need to add in my processing time (Days) column, the Date Recorded Linked.

So basically, I don’t have Date Recorded Completed if I have Date Recorded Linked and vice versa. Do I need an OR formula?

=IFERROR(NETWORKDAYS([Date Started]@row, [Date Recorded Completed]@row), "")

Find more posts tagged with

Accepted answers

Danielle Arteaga

Got it. The formula above should achieve the count using that logic. If there is no date in the [Date Recorded Linked] field, the formula will count the number of workdays between the [Date Started] and the [Date Completed Linked]. Otherwise, it will count the number of days between the [Date Started] and the [Date Recorded Linked].

All comments

Danielle Arteaga

If I follow right, you want to know the number of workdays between the [Date Started] and the [Date Recorded Linked] OR the [Date Recorded Completed].

This should work for you:

=IFERROR(IF(ISBLANK([Date Recorded Linked]@row), NETWORKDAYS([Date Started]@row, [Date Completed Linked]@row), NETWORKDAYS([Date Started]@row, [Date Recorded Linked]@row)), "")

Marilen.Navarro103391

@Danielle Arteaga

I wanted to count the # of Workday between Date Started and Date Recorded Linked, Now if the Date Recorded Linked is blank, I wanted the count the # of Workday between Date Started and Date Recorded Completed.

Thank you.

Danielle Arteaga

Marilen.Navarro103391

@Danielle Arteaga

Just a follow up question, how about if I have 5 column dates recorded. Only one recorded date will appear on the 5 columns. What's my formula on my processing Time (Days). This is a different scenario.... I need to include the 3 below in my formula.

Date Recorded Pipeline

Date Recorded for PO Submitted

Date Recorded for Others- Pricing/Freight

=IFERROR(IF(ISBLANK([Date Recorded Quote]@row), NETWORKDAYS([Date Started]@row, [Date Recorded CE Leads]@row), NETWORKDAYS([Date Started]@row, [Date Recorded Quote]@row)), "")

Thank you.

Danielle Arteaga

Screenshot 2023-11-17 at 11.18.54 AM.png

Place this formula in the column where you want to calculate the number of days since [Date Started]

=IFERROR(IF(NOT(ISBLANK([Date Completed Linked]@row)), NETWORKDAYS([Date Started]@row, [Date Completed Linked]@row), IF(NOT(ISBLANK([Date Recorded Linked]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Linked]@row), IF(NOT(ISBLANK([Date Recorded Pipeline]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Pipeline]@row), IF(NOT(ISBLANK([Date Recorded for PO Submitted]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded for PO Submitted]@row), NETWORKDAYS([Date Started]@row, [Date Recorded for Others- Freight/Pricing]@row))))), "")

NOTE: Another way to do this may be by using a the Change Cell Value automated workflow: https://help.smartsheet.com/articles/2482299-change-cell-value-in-an-automated-workflow

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.