Calculating Avg WD with Stipulations
I'm trying to calculate the average amount of workdays it takes for someone to respond using "Date Forwarded to DPD Command #1" to "Date request is returned from DPD Command #1" while having the "Command #1" column holding that specific command. I've played with it for a while, and can't seem to get it right. I currently have:
=NETWORKDAYS(({DPD FOIA/Subpoena/Litigation Requests Range 1}, {DPD FOIA/Subpoena/Litigation Requests Range 2}, [holidays]), IF({DPD FOIA/Subpoena/Litigation Requests Range 3}, "CSS"))
Trying to get an average for the length of time it took CSS to respond.
Comments
-
I'm not sure I follow exactly.
You are trying to find the average number of days between two columns on a separate sheet for those rows where a third column is "CSS"?
-
I'm trying to make a report that is pulling data from another sheet. The "Date Forwarded..." to the "Date request is returned..." are the two columns (in date form) from which I'm pulling the data. I'm trying to put it on the "Avg WD to Fulfill..." column that's respective to each department.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives