Automate update requests for every week if status is not 100%

dave.mcpherson56751

Hi All,

Is it possible to set up automated update requests until such time that the particular task is complete?

What i am trying to achieve is:

I have a large project involving 360 sites, i have created a sheet with 360 rows and 8 columns of status for different tasks. When a column is complete it adds 12.5% to the % complete column per row.

I would like to send an update request out every Friday to the "Allocated to" recipient if the % complete is not 100%

Any help or guidance would be gratefully received.

Thank  you

Dave

Andrée Starå

Hi Dave,

One way to do it would be to have a column with the date for when you want the update request to be sent. The first row of that column or in another cell you put the date of next Friday and then link that to all the rest of the cells in the update request column.

Set up an update request for yourself or someone else to update that date every week. Set up another rule for the update request to be sent to everyone else.

Not automatic but a good workaround.

It's also possible with the help of a third party solution like Zapier to automate it.

Would that work?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting