Hello Doug,
Thanks for sharing this amazing logic. It works perfectly fine when I use Target/Target History setup. In my snip it says Status/Status History.
I tweaked it a bit to use "Is Active" to track program's active/deactivated status and date. But it works only twice. When I try to activate/deactivate the program third time, the loop stops working. Is there anything wrong with the calculation I used?
Calculation for Status History II:
LEFT(IF(LEFT(Status History II,LEN(IF(ISBLANK(Is Active),"-",Is Active)))=Is Active,Status History II,CONCAT(IF(ISBLANK(Is Active),"-",Is Active)," (",$$NOW,") | ",Status History II)),2000)
