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), "")
Best Answer
-
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].
Answers
-
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)), "")
-
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.
-
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].
-
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.
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!