Ben K.

Perfect, that’s what I needed thanks!

Hmm for some reason I don’t see these two options anywhere. Are these on the free trial?

Thank you! Appreciate the help and quick responses. This was what I was looking for. I’ll use the example you gave as a reference.

It’s not quite what I need. I’m in interested in knowing for example how long has Ben Kochubey been at the company, he’s been at the company 3 years and 1 month. I don’t particularly care to know how long he’s been in a specific role. Is there a way for clay to tell me that this person for example has been at the company for 3 years and 1 month or would I have to use multiple formulas like first finding the difference between start/end date of the first role (data entry specialist) and a second formula finding the difference between the start/end date of the second role (Senior data entry specialist) and then combine them?

Sorry, but I’m still having a hard time getting that info. Here is my table, all these employees are current employees still. I tried changing it to second item instead of first, but it doesn’t give me the total time they’ve been at the company for https://app.clay.com/workspaces/223167/tables/t_JhtQ5OPsRmyi/views/gv_4fKQ5YN8EY8D