Home > Back-end >  How do i write to next Column if Specific Column color changes
How do i write to next Column if Specific Column color changes

Time:10-28

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.

enter image description here

Added & saved the sample function colorChangeCheck as an onChange() installable trigger event type. Guide enter image description here

UPDATE: 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):

enter image description here

  • Related