I'd like to create an automation that does two things.
Trigger: When rows are added or changed I want the following two items to happen.
- Record a date in the column "Completed". Set to today.
- Move row to sheet called "Completed Jobs"
Please let me know if there is a way to do this using conditions?? If so, please give me specifics to make this happen.
Originally I had this set up as two rules however it was copying the rows to the other sheet before setting the date in the "completed" column. I was unable to find a way to reorder the rules ****would be a nice upgrade****
