Is there a metric for Update Request Status?


Currently, I manually update a column, "Update Request Status" with a dropdown of "Sent" and "Received." From there, a metric shows outstanding update requests to completed update requests. Is there an automated process to change a cell value based on the Update Request status?