Close Pending Update Requests when a new update request is sent

Ramsay Zaki
Ramsay Zaki ✭✭✭✭✭✭

I need to send out an automated Update Request weekly. However, I have noticed that whenever someone does not action last week's Update Request and this week's gets sent, Smartsheet now thinks there are two update requests pending. So, even if the person does update using this week's update link, the Update Request icon still appears because of last week's request (which will never get actioned).

I would like to automatically close the previous Update Request whenever a new one is sent. There doesn't appear to be a native way to do this from within Smartsheet... so I'm considering using Microsoft Flow (Power Automate) to do this. But, before I go down that rabbit hole, I wanted to see if anyone else had any ideas.

I have tried sending the recurring update request in two different ways... using Sheet Automation (trigger = date) and also by setting a schedule on the Update Request screen itself. Unfortunately, both create an additional update request and don't close out the previous pending requests.