How to display SUM Total in SharePoint 2016 DataSheet Quick Edit Mode?

Question

I am currently using SharePoint 2016 and I want to be able to display the SUM Total at the bottom of the column during Quick Edit Mode in Datasheet View. This feature used to be available in older SharePoint Datasheet Versions and it is annoying to constantly hit Stop Edit to get a count or sum of items.

Answer 1

Hi @Paul 316 ,

Which older version of SharePoint did you use to support this feature?

In SharePoint server 2016, there is no OOB way to display SUM total on the bottom of list which is in Datasheet View.

When the list is in Quick Edit mode, values in field are dynamic, it is not possible to calculate count or sum of items dynamically.

---------------------------------------------------------------------------------------------------------------------------------------------------------------

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.