Retroactive Workflow Solution

Daniel Barrett

Hi

If I create a workflow to copy rows to a new grid, will it work retroactively if the criteria was met before the automation was created?

For example if my "approved" column has an "If YES move to new sheet" workflow added tomorrow, would anything that has YES in that column from today also move to that grid?

Thanks

Dan

Bassam Khalil

Hi @Daniel Barrett

Hope you are fine, try to create your workflow to copy rows as following and it will copy every rows even before creating your workflow each day at 10:00 am.

Bassam Khalil

Hi @Daniel Barrett

Hope you are fine, try to create your workflow to copy rows as following and it will copy every rows even before creating your workflow each day at 10:00 am.

Daniel Barrett

Hi @Bassam Khalil

Worked perfectly, thank you very much

Bassam Khalil

@Daniel Barrett 

Excellent, I will be happy to help you any time.

Daniel Barrett

Another QQ - is it possible to send those rows based on the name under the "Name"

I'm trying to send each of my team the the rows that are approved for them

So IF Approved = YES and Name = [email protected] THEN send to their sheet

Bassam Khalil

@Daniel Barrett 

You mean instead of copying the rows you want to send them to the assigned team member?

Daniel Barrett

So I am trying to copy all the rows with approved = YES to a separate grid based on the name of the person in the name column

Each teammate will have a spreadsheet dedicated to them and the data will come from a master grid which collects the form responses

Bassam Khalil

@Daniel Barrett 

Sorry for the delay, yes you can do that please try the following workflow ( i assumed that you will copy the row to a grid with my name )