Timestamp field on another field's dropdown value

Hi Chris

You could achieve this easily using a "when record is saved" Workflow. The trigger would be when the status changes to "Won", and the action would be to auto-populate the date as "zero hours from triggered date".

I've had to do this for the majority of my clients, as they want to record the time it takes for a Lead or Opportunity to complete its lifecycle.

Hope this helps!

Philippa

Thanks Philippa - yes a workflow would be easy enough, but for the purposes of this exercise I'd really like to find a way to acheive this by using a calculated field or even a logic hook. Any suggestions on what I'm missing in my calculated field formula?

Hi Chris Hood,

Please try this below formula, I have tested it on my dev env and it worked just fine.

ifElse(isInList($status,createList("Closed")),now(),date("NULL"))

Regards.

Hats

Hi Chris Hood,

Please try this below formula, I have tested it on my dev env and it worked just fine.

ifElse(isInList($status,createList("Closed")),now(),date("NULL"))

Regards.

Hats

Perfect hats Thank you!