Can I send daily update requests with these conditions?

philipwiens

I would like to be able to send update requests to all assignees who have work assigned to them in a daily fashion. 

I have observed that I can send update requests by selecting each row. I have also observed that I can send update requests in a condition where a row is added or changed. These options don't work for what I am trying to do.

Please let me know if there is a way to send update requests, daily, to everyone in the assigned field.

Shawn Connelly

I think this is not an option for good reason. You could end up sending people requests until the end of time, and if they don't have access to disable it and something happened to you, then they would never end.

That said, as a workaround, you could just create a column that you change each day from 1 to 0 one day, and then back to 1 again the next day. You would have to do this for all rows where you have tasks assigned in the sheet. You could also add a column that uses the today() function and use that column as the trigger date for your update request. But you would still have to apply the formula to all rows, and you would have to open the sheet each day, so that the formula will update, but it would be less hassle than having to drag changes all the way down the sheet.