Hi all,
I have a sheet with automation:
Trigger: When Rows are Added or Changed (when 'Project' changes to 'xxx')
Copy rows to.. (defined sheet)
Run workflow: when triggered
Initially this worked a treat.
But, when testing, I had to manually run the automation. Ever since then, it only works if I manually run it on the new rows, defeating the object of it being automated.
I don't want to run the whole thing again so that the rows are duplicated onto the sheets they're copying to
Any ideas how I can get it back to run automatically once the rows are changed.
Thanks
Katie