How does one calculate the amount of HOURS the lead is in status New?
6 answers
Thank you @Sumeet Negi
I found the formula with out having to use a flow:
IF( ISPICKVAL(Status, "New"), TODAY() - DATEVALUE(CreatedDate), DATEVALUE(CreatedDate) - DATEVALUE(CreatedDate) )