I need help with a simple formula (not simple for me hehe). I am trying to figure out how much time it takes for our agents to call a lead (Time To Action column). I had a decent idea of that by using lastmodified-generated on, but this doesn’t take into account the duration of the first call, so it’s wrong by a couple minutes since the stage is only modified after the call. I would need a formula looking like this :
Lastmodified - generated on – time of first call
This would allow us to know exactly how much time it took for the agent to call the lead.
Any help is truly appreciated, thanks🙏