SharePoint List Capability

Question

Can SharePoint Lists do calculations?

1. Calculate mileage - for example we pay someone 40 cents per mile. If they enter a mileage amount can it calculate the reimbursement? (Excel calculation: =S77*0.4 where S77 is total miles)
2. Count calculations -  for example we pay $10 per task performed, calculate the payment for the sum of the tasks performed? (Excel calculation:  =K77*5  where K77 is the total of the tasks performed =COUNTIF(R4:R76,"X").
3. Further,  can I do this by a date range?
4. Is there another SharePoint app I should use?  Can one App feed into another?

This would be totally awesome if I can do it!!!

Thanks in advance for your help!

Answer 1

You should also be told calculated columns have been deprecated in SPO and will no longer work after February 2018 (I think - if you requested an extension). No official replacement has been offered, but you're better off spending your time looking into csr (client side rendering) which allows you to rewrite a list's behavior.

Answer 2

Hi Karin,

In SharePoint Lists, you may try using calculated columns to do calculations. Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library. Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.

For details, check Examples of common formulas in SharePoint Lists. To view all formulas in SharePoint, see the alphabetical list at the end of this article.

Regards,

Felix

Answer 3

Thank you Felix!  I will give it a try!