Calculating Avg WD with Stipulations

Options
fennerb
fennerb ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

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