Automation Workflow

I have a reoccurring task monthly task and I wanna make sure that every month when it's marked completed I wanted to copy that row over to the same sheet or another sheet and have the due date changed to December after the previous month is completed for that specific task ?


is this possible through workflow automation?  

Answers

  • leonastomenio
    leonastomenio ✭✭✭✭

    Yes, this is possible. First, set an automation to trigger every month and add the condition of rows completed like below:

    Then select action as copy rows and select the sheet where it should be copied.

    On the other sheet, add another automation that when there is a new row then it should record a date or replace the cell value like this:

    Hope this helps :)