Welcome!

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.

Find more posts tagged with

Comments

Paul Newcome

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"?

fennerb

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.

Main Snippet.png

Avg Days D.B..png

Sign in to join the conversation!

Quick Links

Trending discussions

Upgrade user mismatch
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
Issues with Email Automations
We are curious if anyone is experiencing issues with automations that are to generate emails. We've been seeing gaps with a number of these automation on various sheets, where the sheet will record a date of when the email was sent, but it is either never received by the recipients or it is received hours or a day later.…
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…