Remove an update request with a formula or workflow?

I have a sheet that will automatically request an update if certain parameters are met. But sometimes the fields get marked directly through the sheet instead of through the update request form. Is there a way to automatically remove the request update if the parameters are met through the sheet? For example if there is an open work order and the update request is to complete the work order fields and close it out, but the employee goes directly to the sheet and closes it out, can the update request be removed when the work order is marked closed? Or do we manually have to delete the update request, as we are currently doing?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!