Hi @CODY_STEWART ,
One solution you can consider here to ensure automation is triggered only for the first time column A is set is:
-
Define another column B as formula ( Auto-fill all the column B cells )
-
=IF(B1=NULL,A1,B1)
-
Now define automation to trigger on this column B update instead of column A.
-
This way only the first time A1 value is computed it will trigger automation to copy row-1. All following updates on A1 will be ignored.
Note: As this solution leverages self-referential formulas, you will need to enable iterative calculations in workbook. Please refer: How to enable iterative calculations?