How to add timestamp before update
I found this calculated custom field on Workfront that display a field's edit history. This calculation adds the date after the update. I've been struggling for hours to try to move the timestamp before the update but with no success. I cannot seem to figure out where my error is at. Can someone please help.
Original calculation code:
LEFT(IF(LEFT({DE:Instructions Edit History},LEN(IF(ISBLANK({DE:Instructions}),"-",{DE:Instructions})))={DE:Instructions},{DE:Instructions Edit History},CONCAT(IF(ISBLANK({DE:Instructions}),"-",{DE:Instructions})," (",$$NOW,") | ",{DE:Instructions Edit History})),2000)
Output: <update> <date> | <previous update history>
I want to move the date first then update, and here is my modification of the code but the keep getting an error that this is invalid.