I have been trying to find a way or method that whenever Specific Column cell color which is Purple changes to another color then write Current date and Time to corresponding column cell.
Added & saved the sample function
colorChangeCheck
as anonChange()
installable trigger event type. GuideUPDATE: Result after changing one purple row to blue and one white row to blue (the white row that was changed to blue has no timestamp):