Hi All
Is there anyway to set an automation to add a new latest comment when a cell changes? In my case, I would like a latest comment to be recorded whenever the Status comlumn is set to complete.
Currently, I have tried the following automation, which doesn't seem to work:
Trigger:When rows are added or changed AND when 'Status' changes to 'Completed'
Actions:Change a cell
Any help would be greatly appreciated.