Avatar

Level 4

Thank you Doug!!! here are my responses:

  • what is the object type for each of the rows in your screenshot? Issue records
  • is Current Status a custom dropdown parameter on a custom form attached to each such row? No is a free text field in a custom form.
  • is Status History a calculated custom parameter on that same custom for attached to each such row? Yes
  • what formula are you using within the Status History calculated custom parameter?

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)