Update Request - Accumulated hours formula
Currently I am setting up a tracker for tracking weekly hours spent on requests that come in via a form.
I would like to set up an update request that runs every friday (until task is marked as closed) to the assigned person who will enter the amount hours they spent on the task in the week just gone.
I would like them to enter just a single number for the week, and calculate a running total of the hours spent. However, I cannot think of a formula that would generate a running total of past weeks hours + the additional hours submitted via the update request without creating several columns.
Any help would be much appreciated as always!