I would like to calculate how long lead and contact is on the same status.
I created a formula field called: Lead Status Age = Today-Lead Status Date.
Every time status changes I am capturing Lead Status Date using workflow.
Challenge when the lead got created by default set to "Status" same happens when the lead gets converted to contact it carries over same "Status" so ISChange() logic is not working.
How can we calculate Lead Status Age? so for example, if Lead or contact gets created with status "Not Contacted" on 4/2/2019 Lead Status Age would be 4 on 4/5/2019 if status again changed to "Sales Working" on 4/5/2019 it would start counting age again.
Thanks.
1 resposta
Hi Archana,
If your workflow only captures ISCHANGED() events, and therefore does not update the status date when a record is created, then you could try changing your criteria formula to:
ISCHANGED(Status) || ISNEW()
This will capture new records as well and update the stage date.
