Avatar

Level 4

Hi !

Thank you for responding to this!. That is a great suggestion, i actually do that to audit information on different workstreams. When i run the code you provided ( very helpful by the way), it tracks the status change, and returns the person who last updated the record, but not the person who updated the status field. The name returned by Last Updated by could have been a resource adding an update to the updates tab, but not necessarily the same person who updated the status field. Thats why I was trying to replace Last Updated By.Name with $$USER.ID. Please see the screenshots,

Thanks in advance for your help

LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Current Status),"-",Current Status)))=Current Status, Status History,CONCAT(IF(ISBLANK(Current Status),"-",Current Status)," (",$$NOW," ", IF(LEN(MINUTE($$NOW))>1, CONCAT(HOUR($$NOW),":",MINUTE($$NOW)), CONCAT(HOUR($$NOW),":0",MINUTE($$NOW)))," by ", Last Updated By.Name , ") | ",Status History)),2000)