AnsweredAssumed Answered

Timestamp field on another field's dropdown value

Question asked by Chris Hood on Sep 12, 2017
Latest reply on Sep 14, 2017 by Chris Hood

I'm trying to create a calculated field that will be used as a timestamp for when a Case's status is updated to Closed. 

 

I have created a custom Datetime field in the Cases module in Studio and using this as my formula:

 

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

 

That formula doesn't appear to do anything when the Case's status is updated to Closed. I've also tried:

 

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

 

And that formula throws an error when I update the status to Closed, saying I need to correct the error before it can save. So it's doing something, but not successfully updating the field to the day/time that the case was marked Closed.

 

I'm running Sugar 7.9.1.0 Professional

Outcomes