Please check this stackblitz example:
Here, if I'm updating the AO cell (i.e Verified By CC) to either Yes or No.
If the value I put is Yes then I need to put today's date in the AN cell (i.e Verified By CC Date) for the same row.
This is working fine if I update each cell individually, i.e AO2, AO3, AO4 one by one. But if I do the drag value, this doesn't work.
And the reason not working is that I'm referring to the sheet.activeCell() .
I wanted to know if there is another way to achieve this (i.e AN cell should be updated if I do drag update on AO cell for all the columns)
Please let me know if you didn't understand or have some confusion about the problem statement.