Can SharePoint lists recognize and calculate Unit of measurements?

Jadarius Anderson 80 Reputation points
2024-01-16T03:50:35.1266667+00:00

Hello, I have a SharePoint Online List that I want to show the total amount for specific items, by certain people or just overall. The Unit of Measurements for these items may be Gallons, Ounces, Liters, Quarts, etc. New items are added to this list almost daily. Is this achievable via my SharePoint list or would I have to export it to excel whenever I need to calculate them?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,197 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 50,006 Reputation points Microsoft Vendor
    2024-01-16T09:32:06.57+00:00

    SharePoint is used to storage and share contents, but not do large data calculations. So, in the OOTB way, SharePoint supports some simple numerical calculations, such as sum, count and etc.

    User's image

    To recognize and calculate Unit of measurements, I suggest you export data to excel, then process data in the excel.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.