Nov 13, 2024 07:17 AM
How do i create a field or metric that shows the time it took to complete a project. for example, tracking the difference from the start date to the date when the project was marked as complete or from in progress to complete. I want to ignore all the other statuses e.g. not started, blocked etc.
Is this possible? Reason i ask is to track this in a dashboard for average project completion time.
Nov 13, 2024 07:34 AM
Hmm, a lot of this depends on your workflow and how your data's set up. If your projects:
1. Never pause (i.e. it's always from Start to Complete)
2. You're using a single select field to set the project statuses
3. "Complete" is the last possible status and you never touch that single select field again after that
Then you can just create a Last Modified Time field to point it at that select field, and the difference between the start date and that Last Modified Time field for projects with a "Complete" status will show you the completion time
---
If your workflows involve projects getting paused in the middle (e.g. being blocked like you mentioned) and then getting started again, one option would be to create a table dedicated to tracking these status changes and you'd use the data from that table to calculate the completion time
You could also handle this without the table and an automation that triggers whenever the status updates, and you'd use some formula fields and logic to figure out whether you want to log this latest status change's time into the project completion time
Nov 14, 2024 02:01 AM - edited Nov 14, 2024 02:02 AM
thanks, ill give this a try, i only want it to depend on only the complete status to be the trigger, so essentially comparing that to the start date and the date the project became 'Complete'
If this is too complicated i don't mind the time between it going from 'not started'/'Start' to 'Complete'