Hi, all, hoping you can help. I’ve reached the end of my rope on this one.
The use case is a support ticketing system for our customers, using a Monday form.
Basically, we want to track the time it takes an employee to close out a support request – starting as soon as the form is submitted, and ending when the employee marks the task as “Done.”
Along the way, we need to auto-assign all incoming tasks to the correct employee, based on which “Support Topic” is chosen by the customer on the Monday form. (I’ve been using a Status column for the Support Topics, which may or may not be ideal.)
So for example, the customer fills out the form, and selects “Shipping” as their Support Topic.
When the form is submitted, it should automatically assign itself to Mary Jones in Shipping.
At the same time, it should automatically start the Time Tracker on the task. The time tracker should keep ticking until Mary marks the task as Done.
Any suggestions for how to structure such an automation?
You can use a Formula column or Dashboard widgets in Monday.com to calculate the time difference between when a task is created and when it’s marked as “Done.” This will give you a clear view of how long each support request takes to resolve, making it easier to track and improve your team’s response times.