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

Multiple Emails in Contact List
I have a contact sheet and a main sheet. There are instances when I have 2-3 individuals that need to be notified based on the information on the main sheet. I created this formula to pull multiple emails from the contact list: =JOIN(COLLECT({Department Chairs}, {CourseName}, CONTAINS([APA Courses]@row , @cell )),…
At location this week, this month
I have created a SmartSheet Travel and Resource calendar where my organization logs in their travel dates, to which operational sites we visit, etc. Each team in the organization has its own sheet, but a dashboard consolidates the information. How can I build a table in the dashboard, that dynamically updates, to show who…
Help with SUMIFS
I am designing a budget sheet and want to Sum a series of cells if they meet 2 conditions. 1st I want it to check an expense category, ie. groceries. I then want it to check that it falls within a specific date range. Below is an example of the formula i have built and it works: =SUMIFS({Expense Collector Range 4},…