- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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)
Views
Replies
0 Likes
Total Likes