Auto-Revoke/Cancel Update Request

Barrett

I have an [Assigned to] contacts column with multiple contacts per cell allowed.

Based on certain criteria I have a workflow setup to send an "Update Request" to all of the contacts in [Assigned to].

However, I only require 1 (one) of the contacts to provide the requested update (as they chose based on their availability).

Typically, when an "Update Request" has been updated and submitted by a single user, their "Update Link", if tried again, will say that this has already been completed or cancelled by the sheet owner.

This is true also when sent to multiple contacts, but only on an individual basis. All other contacts may also Update and Submit (not necessarily noticing the already updated cells) and will thus overwrite.

Locking the entire row is not an option for me.

I need a workflow that will cancel/revoke all other "Update Requests" for a single row once any one update has been posted.

Marc Shecter

Problem:

I have a workflow that sends out an update request to the assigned individual for a task when that task moves into a "late" status. The goal is to get that person to go into the project plan and adjust the end date and or the status of the item.

Many people make this change by editing the smartsheet directly rather than using the "Update Request" form, and now there are many 'Pending' update requests that one must delete manually.

Solution:

Enable a new workflow action that cancells an "Update Request" based on some change in another field. In my example, if the user's task is no longer marked as late, I want the update request to be cancelled.

Megan_ClavieParker

I'm looking for this functionality too, for a different use case. I have an update request that goes out to 3 people, any of whom can complete the update (which is to flip a cell with a drop-down menu to "Complete"). I only want the update completed once, so once the cell changes to Complete I'd like to cancel or revoke the outstanding pending update requests to the other two people. This control is needed because if the cell keeps changing (for example, person 2 changes it to "in progress" or blank and person 3 changes it back to "complete"), it will trigger duplicates of subsequent workflows which could get very messy.

Megan_ClavieParker

Seconded! I need the exact same feature for the same reason.