Measure how long a task has a certain custom field with a certain status?

English Forum Ask the Community
3

I wonder if you can do something like this in Zapier.

e.g.

  1. When custom field changes to “In Progress” update another field to the start date.
  2. Once a day, look at the start date/time and work out the difference from the current date/time.
  3. Then update another field to show “time in progress”.

It’s not an elegant solution, but that’s where I would start to have a play.