I am currently trying to take an existing spreadsheet and replicate this as a SharePoint list.

The spreadsheet contains the following columns:

Received - This will be a number column with 0 decimal places values entered manually
Total In Queue - Same as above
Oldest Date - Date Column values manually added
Worked - This will be a calculated column
Report Category - Choice (Let's call them 1,2 and 3)

There are 3 categories for each item 1 for each mailbox being reported on. There will be one item added per day for each category.

Worked is what is causing difficulty. The Calculation will need to reference information that doesn't yet exist. The formula in excel is


In Terms of columns this would translate to

=SUM([Received],[Total in Queue]-[Next days Total in Queue])

Now as the required information for the calculation won't exist until the next day SharePoint will not allow for this formula to be used. I need to be able to replicate this and everything I have tried has either updated today's item for all 3 categories skewing the data or hasn't had any effect. Can anyone suggest an approach I could Take?

  • Hello, its SharePoint Online or Server? How often should run this, must it be immediately or can be it done within 5minutes? Commented Jan 31, 2019 at 11:41
  • Hello, This is SP2013OP. I'll give you more context on it's purpose. We have a mailbox for requesting call backs. This is to report on the amount coming in, amount worked etc. The report will be added once a day(single item) and will need to update the previous days report with today's total in queue in order to perform the calculation above. There are 3 categories of report and one item will need to be added for each everyday.
    – Kirito
    Commented Jan 31, 2019 at 11:53
  • and it need to update all previous days or only the previous one ? Commented Jan 31, 2019 at 12:18
  • 1
    can you provide as some picture with data as example and what everything must change? Thank you Commented Jan 31, 2019 at 12:19
  • 1
    Ok... My solution didn't work. I'm going to edit the question to try and explain the exact requirements the best I can.
    – Kirito
    Commented Feb 1, 2019 at 13:11


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.