In a list that we use as ticketing tool, I have a field where I have to input my working hours every time.

I'm looking for a way in which I can just input a number in that field but also have another field where all the numbers that I input in the first one are being added.

Following the suggestions in this post, I did the following:

  1. I've created 1 column called "Nr of hours" as Number column with no other settings. This column is included in my Edit Form where I go to put how many hours I worked on something.
  2. I've created another column called "TotHours" as Number column with defalut value 0.
  3. In SPD, I've created a variable called "VarTotHours" as String
  4. Also in SPD, I made a workflow that goes like

    Calculate "Nr of hours" plus "TotHours"(output var "VarTotHours") 
       then Set "TotHours" to "VarTotHours"

Set it up to be activated when an item is changed.

Either it doesn't work at all or it multiplies or keeps on adding without sense.

Any idea why?

Thanks in advance.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.