I have a table with tasks, there are columns “how much time a day to spend on a task to complete it,” “how much time it takes to complete a task”, “time spent on a task today”.
“Time spent on a task today” is calculated by clicking on the button with the formula:
RunActions (ModifyRows (thisRow, [My backlog]. [T worked], Sum ([T worked], Time (0,15,0))), AddOrModifyRows ([Results of the day], [Task] = thisRow. [Task] , [Task], thisRow. [Task], [T per day, plan], thisRow. [T per day, plan], [T worked], sum ([Results of the day]. [T worked], Time (0, 15.0))))
As you can see from the formula, by pressing a button, the time spent on tasks is also logged in another table.
There is a strange error that can only be seen if you click on the button in the first row, then in the second row, and so on. In this case, the “time spent on the task today” is increased not by 15, but by a larger number.
What is the error of my formula?
I provide access for an example. Just don’t get confused, everything is in Russian, Google Translate seems to be translating normally.