We've been asked to calculate how long a ticket has been assigned to one team - and how long it is assigned to another team. (e.g., when the Build team v. the QA team should have been working on the ticket.)
Right now we'd key off of the Assigned To field - but it may be easiest to create a new field that identifies the Assigned To name as being either Build or QA, to just have 2 values to filter off of.
I then need to calculate that a ticket was assigned to Build for x-days and assigned to QA for y-days.
Is this possible to do? Can you help me with a formula to create this?
Bonus points: if there is a way to know it was assigned to Build team for 3 days, then QA for 2 days, then BACK TO the Build team for 4 more days. (A way to know it "bounced", rather than just saying the Build team had it for 7 days.)