Need to track number of update requests sent

We need to be able to track how many times an update request is sent for a particular row (for us 1 row = 1 request). Ideally, we want our field team to submit a project/request when they have all the necessary information, but want a way to count how many times a request is "sent back" to gather additional information. Does anyone have a solution to this?

Answers

  • Adam Murphy
    Adam Murphy ✭✭✭✭✭✭

    One way I can think of is to create a helper sheet and add to your update request automation to copy the row to the helper sheet. You can then use add a column in your main sheet that counts entries in the helper sheet that match the project/request id.