Automation and Latest Comments?

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.

Best Answer

Answers