Copy row automation not working

heather2512

Hi - I have seen various posts about the copy row automation not working. I have looked at the responses and still can't get mine to work.

I think what I am trying to do is simple - I have a master sheet of updates, the cells are updated either by a weekly request update, or manually edited. I want to save the 'current week's report' in a separate sheet before the next update.

I originally had a checkbox that was manually ticked and tried that as the trigger. When that didn't work I changed it to a Yes/No drop down - so that if it was Yes, it would copy the row.

Still now working - please can someone help me understand what I'm doing wrong?

KPH

That looks OK. Do you save the sheet after making the change (or wait long enough for an auto-save)? The row won't copy until the change is saved. Is there another change that is triggered at the same time (which could be happening before this one and preventing it from working)?