Active turn around times by status of a row
I was wondering if theres a way/formula to track the amount of time a line stays in a certain status.
For example - If we are using a line to track the life cycle of a contract we would have a created date field and a contract status field. The status field would consist of fields like "Contract Review" "Legal Review" "On Hold" and "Completed". We only want to see how long of a duration that contract stayed under the contract review status(not counting any days that row is in legal review or on hold. A contract would have an end date of the time it was moved into a completed status
Is this something that can be built out in one of these sheets?
Answers
-
Hi @Scott Czaja
Hope you are fine, you can do that by using the following helper columns an formulas to track each status:
Add a Helper column call it ( Contract Review End Date ) Date type column then create a workflow to Record the date when the contract status change from contract review to any other step and use the following formula to calculate the duration :
In contract review duration = [Contract Review End Date] - [Created Date]
you can do that to monitor all steps duration.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!