It seems as if there's no way to change the rows to be updated in a recurring update request, currently. I think that this is very inconvenient and undermines the power of recurring requests:
- I don't want to bother project managers with requesting status updates on already completed rows
- I don't want to bother them with update requests for not yet relevant rows as well
- I also want to include new rows into existing requests
Right now the only way I see is to adapt the requests whenever the rows to be included change - this is highly inefficient.
My workaround is to have people update reports instead, this allows "moving targets" - however, it doesn't allow update requests, I have to share the reports to do so. Which makes it less convenient in comparison to scheduled update requests.
How do other users handle this? I do not want to share sheets and with respect to completed and not yet active rows this would be somewhat inefficient as well.