Turnaround time for the month of...

I have a sheet with thousands of projects. When a project is finished there is a cell that automatically calculates the turnaround time. There is also a column for the date the project was finished. The projects are not ordered by date. On another sheet I need to calculate the average turnaround time for a given month for projects finished in that month. Does anyone know what formula I can use to do this in smartsheet?

Find more posts tagged with

Calendar View

Formulas

Reports

Cell linking

Comments

MattH

Using

(SUMIF(Month([FinishedDate]) = 1, TurnAroundTime:TurnAroundTime)/Countif(Month([FinishedDate]) = 1)

This will add all of the turn around times and then divide by the number of projects that finished in that month. You'll need to get fancier if you need to look at year, but then you just need to use SUMIFS with Month and Year functions.

All fake code, but it should get you started with the correct functions.

Sign in to join the conversation!

Quick Links

Trending discussions

Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
Why does the parent task my % column show as a decimal value instead of a percentage?
Why does the parent task my % column show as a decimal value instead of a percentage? I checked the column and project settings, and they are identical to another smartsheet in which the values show up as a percentage.
Auto Populate 10 rows with todays date each day
Is there a way to automatically add today's date to 15 new rows each day without deleting previous dates? This would let us track pull the 15 daily task items that need to be completed each day.